Question

In: Finance

Use the following information for the next two questions. You are creating a cash flow project...

Use the following information for the next two questions. You are creating a cash flow project for your new venture, CBD IPA, a cannabis-infused beer and have made the following assumptions for the business:

  • First year sales of 10,000 cans, rising by 10% each year
  • Price per unit of $4.00 each, rising by 2% per year
  • Operating expense equals first year sales revenue and rises 10% per year
  1. What is the projected sales revenue of CBD IPA in year 3 (6 points)?

  

  1. What is the operating income of CBD IPA in Year 4 (6 points)?

  1. Define the profitability index and explain how it may be used a criterion for determining whether to pursue an investment or project (8 points).

Solutions

Expert Solution

1.

Sales revenue in year 3 = Number of canes sales x price per can

                                       = 10,000 x (1.1)2 x $ 4 x (1.02)2

                                                            = 10,000 x 1.21 + $ 4 x 1.0404

                                       = 12,100 x $ 4.1616

                                     = $ 50,355.36

2.

Sales revenue in year 4 = Number of canes sales x price per can

                                       = 10,000 x (1.1)3 x $ 4 x (1.02)3

                                                            = 10,000 x 1.331 + $ 4 x 1.061208

                                       = 13,310 x $ 4.244832

                                     = $ 56,498.71392

Operating expenses in year 4 = First year sales revenue x (1+0.1)3

                                              = $ 10,000 x $ 4 X (1.1)3

                                               = $ 10,000 x $ 4 X 1.331

                                                = $ 53,240

Operating income in year 4 = Sales revenue – Operating expenses

                                           = $ 56,498.71392 - $ 53,240 = $ 3,258.71392 or $ 3,258.71

Profitability index refers to the ratio between discounted benefit to the discounted cost of a project.

It is a useful financial tool to decide the acceptability of investment by measuring the present value of benefit of the project obtained from every dollar invested.

Profitability index greater than one indicates that present value of cash inflows is higher than investment and the project earns a profit and hence acceptable.

Profitability index equal to one reveals the breakeven state of the project. Project is in a no profit and no loss state and all the expenses are covered without generating any profit.

Profitability index less than one points out that present value of cash inflows is less than the amount invested and the project incurring a loss and hence not acceptable.


Related Solutions

Use the following information to answer the next four questions. The cash flows for two mutually...
Use the following information to answer the next four questions. The cash flows for two mutually exclusive projects are shown in the following table. Investors require a 16% rate of return for each project. Year Cash Flows: Project S (in millions) Cash Flows: Project T (in millions) 0 -200 -200 1 -20 50 2 45 60 3 70 30 4 -10 -40 5 125 100 6 125 100 7 150 100 Find the profitability index for project S. Round intermediate...
Use the following information to answer the next three questions. Consider the cash flows from two...
Use the following information to answer the next three questions. Consider the cash flows from two mutually exclusive projects: Cash Flow Year Project A Project B 0 -$470,000 -$460,000 1 $120,000 $392,000 2 $210,000 $110,000 3 $375,000 $120,000 The appropriate discount rate is 11.7%. Calculate the net present value (NPV) for both projects, and determine which project should be accepted based on NPV. Round both NPVs to the nearest dollar. Calculate the internal rate of return (IRR) for both projects,...
Use the following information to answer the next Two questions : 2018 2017 Cash 15,000 14,000...
Use the following information to answer the next Two questions : 2018 2017 Cash 15,000 14,000 A/R 24,000 25,000 Inventory 79,000 78,000 Prepaid Insurance 5,000 4,000 Preoperty plant, & Equipment 35,000 30,000 Accumlated Depreciation (7,000) (5,000) Total Assets 151,000 146,000 Account Payable 6,000 9,000 Bonds Payable (mature in yr 2022 45,000 60,000 Common Stock 70,000 60,000 Retaind Earnings 30,000 17,000 Total Liabilities & Equity 151,000 146,000 Sunny Company had the following comparative balance sheet information for 2018, 2017: Sunny reported...
The following are cash flows for a prospective project. Use this information for the next few...
The following are cash flows for a prospective project. Use this information for the next few problems Year Cash Flow 0 -132,000 1 97,000 2 42,000 3 28,000 A. what is the payback period for the project? B. If the appropriate discount rate for this project is 10%, what is the projects net present value? C. If the appropriate discount rate for this project is 10%, what is the profitability index? D. An argument against accepting the project is that...
Use the following information to answer the next two questions. Consider the after-tax cash flows below:...
Use the following information to answer the next two questions. Consider the after-tax cash flows below: Year 0 1 2 3 4 Cash Flow -$75,000 $5,100 -$1,100 $498,000 -$272,000 The required rate of return is 12 percent. Find an internal rate of return (IRR) for these cash flows. Should you use the IRR you calculated in the previous question to decide whether the project is acceptable? Explain show work please
Use the following information for the next three (3) questions. MARIKINA Company had the following cash...
Use the following information for the next three (3) questions. MARIKINA Company had the following cash transactions: Cash collected from customers 12,500 Cash received from a loan 8,000 Cash paid for wages payable 5,750 Cash paid for the purchase of a building 15,000 Cash received for the issuance of new shares of stock 2,600 Cash received from sale of land 6,400 Cash paid for rent 2,500 Cash paid for dividends 1,500 1.What is the net cash provided by operating activities?...
Use the following information to answer the next three questions. Consider the following cash flows: Year...
Use the following information to answer the next three questions. Consider the following cash flows: Year Cash Flow 0 -$2,110,000 1 1,000,000 2 450,000 3 790,000 4 890,000 Assume a discount rate of 17.5 percent. What is the payback period? Round your answer to two decimal places. What is the net present value (NPV) rounded to the nearest dollar? What is the internal rate of return? please show work.
Use the following information to answer the next three questions. Consider the following cash flows: Year...
Use the following information to answer the next three questions. Consider the following cash flows: Year Cash Flow 0 -$2,110,000 1 1,000,000 2 450,000 3 790,000 4 890,000 Assume a discount rate of 17.5 percent. What is the payback period? Round your answer to two decimal places. What is the net present value (NPV) rounded to the nearest dollar? What is the internal rate of return? please show work
What is the company’s Free Cash Flow (FCF)? Use the information to answer the following questions....
What is the company’s Free Cash Flow (FCF)? Use the information to answer the following questions. XXX, Inc. Balance Sheet 2008 2007 2008 2007 Cash 450 200 Accounts Payable 1700 1500 Accounts Receivable 3600 2500 Notes Payable 1200 500 Inventory 3200 2000 Total CL 2900 2000 Total CA 7250 4700 Long Term Debt 3970 2000 Gross Fixed Assets 7200 5500 Common Stock 3100 3000 Less Acc. Depreciation 1400 1200 Retained Earnings 3080 2000 Net Fixed Assets 5800 4300 Total Equities...
Use the following information to answer the next two questions: Stock                  Amount            &nb
Use the following information to answer the next two questions: Stock                  Amount                       Beta A                         25,000                         0.2 B                         20,000                         1.0 C                         30,000                         1.8 D                         25,000                         1.6 Risk-free rate is 3% and the market risk premium is 8% What is the required return for this portfolio?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT