Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave

Breakeven Analysis

Discuss about the Financial Feasibility of the Business.

Mrs. Fanny who lives in Chicago has recently taken retirement and has received a sum of $475000 for 30 years of work with the pharmaceutical company. She has decided to start a new venture with the amount in hand. Mrs. Fanny wants to sell gourmet chocolates imported from France in the US markets. She will be purchasing the gourmet chocolates from Choc-O-LaySA an established company in France which is known for its fine chocolates with unusual and innovative flavors. Choc-O-LaySA will provide Mrs. Fanny exclusive rights to sell their products in USA. Mrs. Fanny will have to provide an upfront payment for the exclusive rights and the rights will be for 5 years. Her husband has decided to support her with her new business idea and has suggested to develop a financial plan for the feasibility of the business.

Mrs. Fanny has conducted a market study in the USA to understand the demand of the gourmet chocolate and the price people will be willing to pay for the gourmet chocolate from France. The market survey by Mrs. Fanny revealed that the demand for the gourmet chocolate will be 750kg a month. But initially the demand will be only 75kg and gradually grow to its full potential and Mrs. Fanny will be able to sell 750kg a month by the end of the first year. The cost of the market study was $6500. Also it was found that the demand for the gourmet chocolate was price elastic i.e. the demand for the gourmet chocolate could be double if Mrs. Fanny reduced the price by 10%. Mrs. Fanny has decide to sell the gourmet chocolate directly to the customers via internet only and for this purpose has got in touch with a website developer who can make a website for her at $3500. She will require a refrigerator which will cost her $5250. The other expenses which Mrs. Fanny will have to incur are the packaging and shipping cost of the gourmet chocolate to the customers which is at $2 per kg, credit card interest cost by the credit card company at 1% of the sales, rent of the office from where Mrs. Fanny will operate is $420 with a 3 month deposit to be paid and the cost of the employee who will help Mrs. Fanny with the business which will cost her $2650 per month.

Profit and Loss Statement

Apart from the internet sales, Mrs. Fanny will also be able to sell her gourmet chocolate t her friend Mrs. Mitch. Mrs. Mitch runs a small chain of delicatessens in Chicago. She is interested in Mrs. Fanny’s venture and has promised to purchase gourmet chocolate from her. However, she wants her to pack the gourmet chocolate in tin boxes with each tin box containing 550g of chocolates. She said if Mrs. Fanny could provide the same she will be purchasing 100 such boxes per month. The cost of purchasing such tin boxes is $1.75 per box and selling price would be $62. The assistant who can help Mrs. Fanny with processing such boxes will charge $750 per month. Mrs. Fanny will have to pay tax at 30% of the total profit generated every year. She can also request a loan of $50000 at 8% p.a.

Mrs. Fanny wants to understand the financial implications of her business so that she can decide whether she should go ahead with this business or not.

Breakeven Analysis is a method to find the revenue a business must generate such that the total revenue is equal to the total cost of the business. i.e. at Breakeven point there is no profit and loss.

It is given by Break even analysis =   (Gallo, 2014)

Cost of import of gourmet chocolates = €68.875 / kg = $76.45 [ €1 = $1.11]

Transportation cost from France to USA = € 18/ kg = $19.98

Shipping cost = $2/ kg

Revenue = $120/ kg

Credit Card cost = 1% of revenue = $12

Unit margin = 120 – 76.45 – 19.98 – 2 - 12 = $9.57

Refrigerator cost = $5250

Market study cost = $6500

Website design cost = $3500

Salary cost = $ 31800

Rent = $5040

Fixed costs = $5250 + 6500 +3500 + 40800 + 5040 = 61090

Thus breakeven point = 61090/ 9.57 = 5443.05 kg

Thus Mrs. Fanny should sell more than 5443.05 kg of gourmet chocolate to earn profit. If the number of chocolates sold through internet is less than 5443kg then she will not be able to cover the fixed cost of $61090 she will incur.

The net income of each month is given below. The company will be able to breakeven in 12 months.

Month

0

1

2

3

4

5

6

7

8

9

10

11

12

Net income

-24312

-11456

-3644

-2566

-1420

-275

871

2017

3163

4308

5454

6600

87458

Cumulative

-24312

-35768

-39412

-41979

-43399

-43674

-42803

-40786

-37623

-33315

-27861

-21261

66197

ITEMS

ITEM BREAKUP

FIRST YR.

Operating Revenue

Sale from Internet

627750.00

Other Revenue

Sales to Mitch

74400.00

Total Revenue

 

702150.00

Cost of Goods sold

chocolate imported from France

557013.80

Operating Expenses

Salary

Assistant and Employee

40800.00

Rent

5040.00

Market Study

6500.00

Credit card

1% of the revenue

7021.50

Shipping cost

Due to sales on internet

10462.50

Depreciation

Assuming Straight line for 5 years

1050.00

EBIT

Revenue minus expenses

74262.00

Net Interest Expense

No loan taken

0.00

PreTax Profit

revenue minus operating and interest expenses

74262

Tax Expense

30%on earned income

22278.66

Net Profit after Tax

total revenue minus tax expenses

51983.54

The Profit and loss statement is a financial statement which helps in summarizing the revenues, expenses and recording profit for a specific period (usually a year). This statement is useful for the investors and owners to understand the revenues generated by the company and if the business is able to generate profits for the shareholders. (Investopedia)

The Profit and loss statement can be divided into Operating revenue, Other revenue, Operating expenses, EBIT and Profit.

Operating revenue – The Operating revenue of the company is the revenue generated by the company from daily sales. Thus it is the main source of income of the business. In this case, the sale of gourmet chocolate to the customers via internet is the primary source of revenue and hence the operating revenue. The company was able to sell 5231.25 kg via internet at $120 per kg and hence the operating revenue = $627750.

Other revenue – The Other revenue of the company is the revenue generated by the company from sources other than daily sales. Thus it is secondary source of income of the business. In this case, the sale of gourmet chocolate to Mrs. Keith was the secondary source of income of the business and hence the other revenue. The company was able to sell 1200 units to Mrs. Keith at $62 per box. Hence the other revenue = $74400.

Thus the total revenue of the company = 627750 + 74400 = $702150.

Operating expense: The Operating expense of the company is the expense incurred by the company to complete it sales. In this case, the Operating expenses include cost of import goods sold, rent of office, salary to the employees, credit card cost, market study cost, depreciation and shipping cost. Thus total operating expense = 557013.80 + 5040 + 40800 + 7021.50 + 6500 + 1050 + 10462.50 = 627887.80

Assuming the life of the refrigerator to be 5 year and applying straight line depreciation on the refrigerator we get depreciation = 5250/ 5 = 1050.

EBIT: EBIT is earnings before interest and taxes. It is the earning of the company by reducing all the expenses from the revenue earned by the company to get the earnings of the company before it pays interest on loan (if any) and taxes . For the business EBIT is calculate by subtracting the operating expense from the operating revenue. Thus EBIT = 702150 – 557013.80 = $74262.20

Interest expense – It is the amount of money to be paid by the business as interest over the loan taken by the company. This amount is deducted from the EBIT before tax is implemented on the earnings as no tax is implemented on the interest. Mrs. Fanny has not taken any loan for the business. Hence the interest expense = 0

Net Profit – The Net Profit of the company is the amount of profit generated by the company by doing business after paying taxes and can be given to the investors in the form of dividend or reused in the business in form of retained earnings. Net Profit = Profit Before Tax – taxes = 74262.20 – 22278.66 = $51983.54.

Taxes = 30% of 74262.20 = 0.3* 74262.20 = 22278.66

Conclusion – Thus from the Profit and loss statement of the given business it can be said that the business will be able to generate profit in the first year and it will be equal to $51983.54. The revenue generated from sales was 702150 and the operating expenses were 627887.80. The net profit generated by the business is quite high and Mrs. Fanny will be able to easily expand her business and pay royalty to Choc. The overall financial health of the company looks good from the Profit and loss statement. Thus Mrs. Fanny should go ahead with this venture as the business will be able to generate profits in a year.

The Balance Sheet of a company is the financial statement which summarizes the total assets, liabilities and equity of the company at a given point in time. The Balance Sheet has three important parts: Assets, Liabilities and Shareholder’s Equity

For any Balance Sheet, Assets = Liabilities + Shareholder’s Equity. (Averkamp, 2015)

The following is the balance sheet for Mrs. Fanny

ITEMS

ITEMS Breakup

FIRST YR

CA – Cash

Generated from sales

68597.45

CA – Receivables

credit sales to customers

96200.00

CA – Rent Deposit

three month deposit

1260.00

CA – Inventories

Chocolate and tin inventory

76703.26

Total Current Assets

 

242760.70

NCA – Equipment

Refrigerator

5250.00

Accumulated Depreciation

Life = 5 years and straight line

1050.00

NCA – Investments

website

3500.00

Total NCA

 

7700.00

Total Assets

CA+NCA

250460.71

CL - Account Payable

suppliers, wages, yearly rent

159688.51

Total Curr. Liabilities

 

159688.51

Total NCL

 

0

Total Liabilities

 

159688.50

Equity

 

38788.66

Retained Earnings

519683.54

Total Equity

90772.20

The balance sheet can be broken into Assets which consist of Current Assets and Non Current Assets, Liabilities which consist of Current Liabilities and Non Current Liabilities and equity which has shareholder’s equity and retained earnings.

CA or Currents Assets – The Currents Assets includes all the cash and cash equivalent of the company which can be easily converted to cash. Eg Cash, securities, advance payment, accounts receivables, inventory, etc. In this case Current assets of the company = $242760.71.

NCA or Non Currents Assets – The Non Currents Assets of the company are assets which take longer to convert to cash (more than one year). Eg Equipment, Investment in Website etc. In this case Non Current assets of the company = $7700.

Thus the total assets of the company = 242760.71 + 7700 = 250460.71.

CL or Currents Liabilities– The Currents Liabilities are all the liabilities the company needs to pay to its account holders in a short span of time (less than one year). Eg Salary, rent, accounts payable, etc. In this case Current Liabilities of the company = $159688.51.

NCL or Non Currents Liabilities – The Non Currents Liabilities of the company are liabilities which the company needs to pay back in a longer period of time (more than one year).. In this case Non Current assets of the company = $0.

Thus the total liabilities of the company = 159688.51 + 0 = 159688.51.

Shareholder’s Equity: The Shareholder’s Equity consists of two parts: equity and retained earnings. Equity is the amount invested by the owners in the company to run the business. Retained earnings is the amount generated by the business as profit and which is reinvested in the business to help the business grow rather than sharing it with the shareholders.

In this case Equity = 38788.66 and retained earnings = 51983.54.

Thus Shareholder’s Equity = 38788.66 + 51983.54 = 90772.20

The cash Flow Statement of a company tells in detail about the cash transactions of the company and helps in determining the cash present with the firm at any given point in time. In a business, the cash is used for operating activities (day to day operations of the business), investing activities (investment in long term assets like plant, property, machinery, etc.) and financing activities (purchase of shares, securities etc.)

Cash Flow statement Month 1

Operating Activities

Total revenue

0.00

Cogs

7232.44

Net income

-7232.44

Rent

-420.00

Credit card

0.00

Salary

-3400.00

Cash used in operating activities

-11052.44

Investment Activities

Refrigerator

-5250.00

Website design

-3500.00

Rent advance Deposit

-1260.00

Prepaid tax

-22278.66

Market Study

-6500.00

Cash used in investing activities

-38788.66

Financing activities

Equity

38788.66

The operating activities of the 1st month are: Revenue, Cost of goods sold, rent, salary, credit card cost.

In the 1st month, the amount of gourmet chocolate sold will be received in the next month by the credit card company. Thus Revenue = 0.

The Cost of goods sold is the amount paid for the purchase of the gourmet chocolate and shipping them to USA. COGS = $7232.44

Rent for the month = $420

Salary to the employees = 2650 + 750 = $3400

Since No revenue received this month, the cost of credit card = 0

Thus total cash flow in the operating activities = - (7232.44 + 420 + 3400 + 0) = - 11052.44

The amount is spent hence the cash flow is negative.

The investment activities in the first month are purchase of Refrigerator, website design, market study, rent advance deposit and prepaid tax.

Cost of refrigerator = 5250

Website design = 3500

Market study = 6500

Rent advance = 1260

Prepaid tax = 22278.66

Thus total cash flow in the investing activities = - (5250 + 3500 + 6500 +1260 + 22278.66)

= - $38788.66

The financing activities in the first month is the amount invested by the Mrs. Fanny which is = $38788.66.

Conclusion:

The net cash flow value in the 1st month is negative. i.e. the cash outflow is more than the cash inflows. The revenue for this month will be realized in the next month so the income is zero but the expenditure for the month takes place hence net operating cash flow is negative. In the investment activities the cash outflow takes place due to purchase of assets and hence net investing cash flow is negative. In the financing activities, the cash inflow takes place due to investment from the equity. 

Cash Flow statement Year 1

Operating Activities

Total revenue

702150.00

Cogs

-504455.98

Net income

197694.02

Rent

-5040.00

Credit card

-7021.50

Salary

-40800.00

Shipping cost

-10462.50

Cash used in operating activities

134370.02

Investment Activities

Refrigerator

-5250.00

Website design

-3500.00

Deposit

-1260.00

Prepaid tax

-22278.66

Market Study

-6500.00

Cash used in investing activities

-38788.66

Financing activities

Equity

38788.66

Net cash

51983.54

The annual cash flow statement tells about the cash that goes in and out of the business. It helps in understanding where the cash was used and which the sources of revenue were for the company. The investors are interested in cash flow statement as it helps in determining whether the business will help them make profits and helps in understanding the viability of the business.

In this case the net cash from the operating, investing and the financing activities is positive i.e. by doing the business the company will be generating more cash.

Conclusion:

The net cash flow is positive i.e. the company is able to generate cash by doing the business. Thus Mrs. Fanny should invest in the business as the business is profitable at the end of the first year.

The discounted cash flow method is used for the valuation of the project by taking time value of money into consideration. In Discounted Cash Flow Analysis, the cash flow all the future years of the project is estimated and the these cash flows are discounted to their present value using the discount rate. If the sum of the discounted cash flow is less than the initial investment by the company, the company should not go ahead with the project but if the sum of the discounted cash flow is more than the initial investment by the company then the company should take the project as it will be profitable for the company. (Stockopedia, 2012)

PV = present value = FV/ (1+r)n Where r is the discount rate and n is the number of years before the cash flow occurs, FV = future value of the cash flow.

In this case, assuming straight line depreciation of the refrigerator with salvage value = 0 and life = 5 year, depreciation is calculated.

Depreciation = (5250 - 0)/ 5 = 1050

Thus the Income statement for the next 5 years, assuming Mrs. Fanny is able to sell 750kg of gourmet chocolate each month is given below.

Income Statement 5 years

         

Year

1

2

3

4

5

kg of chocolates sold

5231.25

9000.00

9000.00

9000.00

9000.00

Sales

627750.00

1080000.00

1080000.00

1080000.00

1080000.00

Revenue from sales to Mitch

74400.00

74400.00

74400.00

74400.00

74400.00

Total revenue

702150.00

1154400.00

1154400.00

1154400.00

1154400.00

Expenses

         

Rent

5040.00

5040.00

5040.00

5040.00

5040.00

Import of chocolate

504455.98

867881.25

867881.25

867881.25

867881.25

Shipping cost

10462.50

18000.00

18000.00

18000.00

18000.00

Credit card

7021.50

11544.00

11544.00

11544.00

11544.00

Employee salary

40800.00

40800.00

40800.00

40800.00

40800.00

Cost due to sales to Mitch

52557.83

52557.83

52557.83

52557.83

52557.83

Market Study

6500.00

0.00

0.00

0.00

0.00

Depreciation

1050

1050

1050

1050

1050

Total Expenditure

627887.80

996873.08

996873.08

996873.08

996873.08

Profit before Tax

74262.20

157526.93

157526.93

157526.93

157526.93

Tax

22278.66

47258.08

47258.08

47258.08

47258.08

PAT

51983.54

110268.85

110268.85

110268.85

110268.85

The discount rate is given as 4%. Hence calculating the DCF for the 5 years we get

Discount rate @4%

1

2

3

4

5

Discounted cash flow

37131.10

56259.62

40185.44

28703.89

20502.78

Initial investment = 38788.66

Thus the net value of the project = -38788.66 + 37131.10 + 56259.62 + 40185.44 + 28703.89 + 20502.78 = $166272.82

Conclusion: Thus the net value of the project has been calculated and was found to be 166272.82. Thus by taking up the project Mrs. Fanny will earn $166272.82. Also the royalty she needs to pay to Choc-O-LaySA should be less than 166272.82 if she wants to earn a profit from the business.

Sensitivity Analysis helps in finding how the change in an input value will affect the other dependent variables while the other assumptions are kept constant. (Investopedia, 2015). In this case the decrease in selling price by 10% will increase the demand by 2 times.

Thus the company will be able to sell 150kg in the 1st month and the year-end monthly demand will increase to 1500 kg.

Thus the new monthly cash flow statement will

Month

0

1

2

3

4

5

6

7

8

9

10

11

12

kg of chocolate sold

 

150

375

487.5

600

712.5

825

937.5

1050

1162.5

1275

1387.5

1500

Sales

 

16200

40500

52650

64800

76950

89100

101250

113400

125550

137700

149850

162000

Revenue from sales to Keith

 

6200

6200

6200

6200

6200

6200

6200

6200

6200

6200

6200

6200

Total revenue

 

22400

46700

58850

71000

83150

95300

107450

119600

131750

143900

156050

168200

Expenses

                         

Initial Investment

16510

                       

Rent

 

420

420

420

420

420

420

420

420

420

420

420

420

Import of chocolate

14465

36162

47010

57859

68707

79556

90404

101253

112101

122950

133798

144647

 

Shipping cost

300

750

975

1200

1425

1650

1875

2100

2325

2550

2775

3000

 

Credit card

 

224

467

588.5

710

831.5

953

1074.5

1196

1317.5

1439

1560.5

1682

Employee salary

 

3400

3400

3400

3400

3400

3400

3400

3400

3400

3400

3400

3400

Cost due to sales to Mitch

 

4380

4380

4380

4380

4380

4380

4380

4380

4380

4380

4380

4380

Total Expenditure

31275

45336

56652

67847

79042

90237

101432

112627

123822

135017

146212

157407

9882

Tax Prepaid

16957

                       

Cash Flow each month

-48231

-45336

-34252

-21147

-20192

-19237

-18282

-17327

-16372

-15417

-14462

-13507

146168

Thus it can be seen that the company will be able to recover the initial investment in 12 months and the profits will be much more than the profits earned at the current selling price. Hence the company should reduce the price.

Conclusion

Thus from the financial analysis I think Mrs. Fanny should go ahead with the venture as the business can breakeven in a year and generate profits for her and think that she should reduce her price by 10% so that profits are increased.

The following recommendations which I think can help Mrs. Fanny to run the business in a better way

1. In my view, the company should hedge the currency so that the fluctuations in dollar euro conversion rate will not affect the business

2. I would suggest Mrs. Fanny to choose suitable method of depreciation of assets to reduce the tax burden on the company.

3. I would recommend Mrs. Fanny to buy rights from Choc-O-LaySA at a price less than to earn profits in the business.

4. I think the company can reduce the shipping cost and bring efficiency in the distribution process to save on the spending.

5. In my view, investment in advertisement can help to increase the demand for the gourmet chocolate and hence the profitability of the business be increased.

References

Gallo,A. (2014). A Quick Guide to Breakeven Analysis. Retrieved on August 5, 2016 from https://hbr.org/2014/07/a-quick-guide-to-breakeven-analysis

Averkamp, H. (2015). Introduction to Balance Sheet. Retrieved on August 5, 2016 from https://www.accountingcoach.com/balance-sheet/explanation

Investopedia. (n.d.). Income Statement.  Retrieved on August 5, 2016 https://www.investopedia.com/terms/i/incomestatement.asp

Investopedia. (2015). Sensitivity Analysis.  Retrieved on August 5, 2016 https://www.investopedia.com/terms/s/sensitivityanalysis.asp

Stockopedia. (2012). What is a DCF Valuation? Retrieved on August 5, 2016 https://www.stockopedia.com/content/valuation-101-how-to-do-a-discounted-cashflow-analysis-63489/

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2017). Financial Feasibility Of Selling Gourmet Chocolates In US Market - Essay.. Retrieved from https://myassignmenthelp.com/free-samples/financial-feasibility-of-the-business.

"Financial Feasibility Of Selling Gourmet Chocolates In US Market - Essay.." My Assignment Help, 2017, https://myassignmenthelp.com/free-samples/financial-feasibility-of-the-business.

My Assignment Help (2017) Financial Feasibility Of Selling Gourmet Chocolates In US Market - Essay. [Online]. Available from: https://myassignmenthelp.com/free-samples/financial-feasibility-of-the-business
[Accessed 21 November 2024].

My Assignment Help. 'Financial Feasibility Of Selling Gourmet Chocolates In US Market - Essay.' (My Assignment Help, 2017) <https://myassignmenthelp.com/free-samples/financial-feasibility-of-the-business> accessed 21 November 2024.

My Assignment Help. Financial Feasibility Of Selling Gourmet Chocolates In US Market - Essay. [Internet]. My Assignment Help. 2017 [cited 21 November 2024]. Available from: https://myassignmenthelp.com/free-samples/financial-feasibility-of-the-business.

Get instant help from 5000+ experts for
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

loader
250 words
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Plagiarism checker
Verify originality of an essay
essay
Generate unique essays in a jiffy
Plagiarism checker
Cite sources with ease
support
close