Proposal 1
Year for proposal | 0 | 1 | 2 | 3 | 4 |
Year Actual | 20x2 | 20x3 | 20x4 | 20x5 | 20x6 |
Sales ( 5,000 * $7.50 * 12 months) | 450,000 | 450,000 | 450,000 | 450,000 | |
Less:- Incremental Cash Outlay | (250,000) | (250,000) | (250,000) | (250,000) | |
Less:- Depreciation as per ACRS | (100,000) | (152,000) | (148,000) | - | |
Net Profit Before Tax | 100,000 | 48,000 | 52,000 | 200,000 | |
Less:- Tax @ 30% | (30,000) | (14,400) | (15,600) | (60,000) | |
Net Profit After Tax | 70,000 | 33,600 | 36,400 | 140,000 | |
Add:- Depreciation | 100,000 | 152,000 | 148,000 | - | |
Cash Flow From Operations | 170,000 | 185,600 | 184,400 | 140,000 | |
Purchase of Equipment | (400,000) | ||||
Total Cash Flows | (400,000) | 170,000 | 185,600 | 184,400 | 140,000 |
PV Factor @ 16% | 1.000000 | 0.862069 | 0.743163 | 0.640658 | 0.552291 |
PV of Total Cash Flows | (400,000.00) | 146,551.72 | 137,931.03 | 118,137.28 | 77,320.75 |
Net Present Value of Proposal 1 | 79,940.79 |
Proposal 2
Contribution per unit = Sale Price- Manufacturing - Selling Expense = 15 - 6 -1 =$8 per unit
Year for proposal | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
Year Actual | 20x2 | 20x3 | 20x4 | 20x5 | 20x6 | 20x7 | 20x8 |
Sales (in Units) | 65,000 | 90,000 | 90,000 | 65,000 | 50,000 | 50,000 | |
Contribution Per Unit | 8 | 8 | 8 | 8 | 8 | 8 | |
Contribution Margin (Sales * $8) | 520,000 | 720,000 | 720,000 | 520,000 | 400,000 | 400,000 | |
Less:- Incremental Cash Outlay | (300,000) | (300,000) | (300,000) | (300,000) | (300,000) | (300,000) | |
Less:- Depreciation as per ACRS | (175,000) | (266,000) | (259,000) | - | - | - | |
Add:- Gain on Sale of Equipment | - | - | - | - | - | 50,000 | |
Net Profit Before Tax | 45,000 | 154,000 | 161,000 | 220,000 | 100,000 | 150,000 | |
Less:- Tax @ 30% | (13,500) | (46,200) | (48,300) | (66,000) | (30,000) | (45,000) | |
Net Profit After Tax | 31,500 | 107,800 | 112,700 | 154,000 | 70,000 | 105,000 | |
Add:- Depreciation | 175,000 | 266,000 | 259,000 | - | - | - | |
Cash Flow From Operations | 206,500 | 373,800 | 371,700 | 154,000 | 70,000 | 105,000 | |
Purchase of Equipment | (700,000) | ||||||
Total Cash Flows | (700,000) | 206,500 | 373,800 | 371,700 | 154,000 | 70,000 | 105,000 |
PV Factor @ 16% | 1.000000 | 0.862069 | 0.743163 | 0.640658 | 0.552291 | 0.476113 | 0.410442 |
PV of Total Cash Flows | (700,000.00) | 178,017.24 | 277,794.29 | 238,132.46 | 85,052.83 | 33,327.91 | 43,096.44 |
Net Present Value of Proposal 2 | 155,421.17 |
Note:- The Salvage value of $50,000 in proposal 2 is treated as normal income and fully taxed at 30% because earlier depreciation for full $700,000 had been taken. Alternate treatment according to country and tax laws may be possible.
The Net Present Value of the two proposals has been calculated as above.
Feel free to comment in case of any doubts. Please hit like if this helps!
4.. Net Present Value. (CMA adapted) Crescent Industries is a toy manufacturer that will have excess...
Elon Motors produces electric automobiles. In recent years, they have been making all components of the cars, excluding the batteries for each vehicle. The company's leadership team has been considering the ways to reduce the cost of producing its cars. They have considered various options, and believe that they could reduce the cost of each car if they produce the car batteries instead of purchasing them from their current vendor, Avari Battery Company.Currently, the cost of each battery is $300...
Question 4 Nubela Manufacturing is considering two alternative investment proposals with the following data: Not yet answered Marked out of 2.00 P Flag question Proposal X Proposal Y Investment $10,700,000 $580,000 Useful life 5 years 5 years Estimated annual net cash inflows for 5 years $2,140,000 $103,000 Residual value $50,000 $26,000 Depreciation method Straight-line Straight-line Required rate of return 12% 13% Calculate the payback period for Proposal X Select one: O A 8 years OB. 4 years O c. 9...
Case: Investment Proposals for Ontario Coffee Home It is January 1, 2019. You are a Senior Analyst at Ontario Coffee Home (OCH), one of the leading coffee chains and wholesaler of coffee/bakery products in Ontario. The CEO of Ontario Coffee Home, Jerry Donovan, has reached out to you to draft a report to evaluate two investment proposals. Requirements 1. Identify which revenues and costs are relevant to your analysis, and which costs are irrelevant. Summarize all the information that will be...
Case: Investment Proposals for Ontario Coffee HomeIt is January 1, 2019. You are a Senior Analyst at Ontario Coffee Home (OCH), one of the leading coffee chains and wholesaler of coffee/bakery products in Ontario. The CEO of Ontario Coffee Home, Jerry Donovan, has reached out to you to draft a report to evaluate two investment proposals.Requirements1. Identify which revenues and costs are relevant to your analysis, and which costs are irrelevant. Summarize all the information that will be required for each...
Case: Investment Proposals for Ontario Coffee Home It is January 1, 2019. You are a Senior Analyst at Ontario Coffee Home (OCH), one of the leading coffee chains and wholesaler of coffee/bakery products in Ontario. The CEO of Ontario Coffee Home, Jerry Donovan, has reached out to you to draft a report to evaluate two investment proposals. Requirements 1. Identify which revenues and costs are relevant to your analysis, and which costs are irrelevant. Summarize all the information that will...
Case: Investment Proposals for Ontario Coffee Home It is January 1, 2019. You are a Senior Analyst at Ontario Coffee Home (OCH), one of the leading coffee chains and wholesaler of coffee/bakery products in Ontario. The CEO of Ontario Coffee Home, Jerry Donovan, has reached out to you to draft a report to evaluate two investment proposals. Requirements 1. Identify which revenues and costs are relevant to your analysis, and which costs are irrelevant. Summarize all the information that will be...
Description In three units of study, there will be application-focused cases due at the beginning of the class that will be provided by the instructor. These cases will be complex in nature and will require the application of course concepts to real-word business situations. Each case will have an associated rubric to highlight expectations. All submissions must be of professional quality and done in Microsoft Word, Microsoft Excel, or submitted as a PDF. Case: Investment Proposals for Ontario Coffee Home...
What should have Merck & Co, Inc done differently in regards to river blindness? Merck & Company, Inc.: Having the Vision to Succeed by Stephanie Weiss and David Bollier An Expensive Care for a Poor Market In 1978, Dr. P. Roy Vagelos, then head of the Merck research labs, received a provocative memorandum from a senior researcher in parasitology, Dr. William C. Campbell. Dr. Campbell had made an intriguing observation while working with ivennectin, a new antiparasitic compound under investigation...
4. Perform a SWOT analysis for Fitbit. Based on your assessment of these, what are some strategic options for Fitbit going forward? 5. Analyze the company’s financial performance. Do trends suggest that Fitbit’s strategy is working? 6.What recommendations would you make to Fitbit management to address the most important strategic issues facing the company? Fitbit, Inc., in 2017: Can Revive Its Strategy and It Reverse Mounting Losses? connect ROCHELLE R. BRUNSON Baylor University MARLENE M. REED Baylor University in the...