In: Finance
Daily Enterprises is purchasing a $10,000,000 machine. The machine will be depreciated using straight-line depreciation over its 8 year life and will have no salvage value. The machine will generate revenues of $7,500,000 per year along with fixed costs of $3,500,000 per year.
If Daily's marginal tax rate is 31%, what will be the cash flow in each of years 1 to 8 (the cash flow will be the same each year)?
Enter your answer rounded to the nearest whole number. (3147500)
If the discount rate is 12%, what is the NPV of the project? The cash flow each year is $3,147,500.
Enter your answer rounded to the nearest whole number. (5635646)
Question: Find the Net Present value Break-even level of revenues, assuming the costs are all fixed costs. Enter your answer rounded to the nearest whole number.
the answer is 5,855,838. How can I get this answer?
Cash flows for the year 1 to 8 :
| Sales | Cost | Depn | PBT | Tax | PAT | Depreciation | Cash Flow | 
| 7500000 | 3500000 | 1250000 | 2750000 | 852500 | 1897500 | 1250000 | 3147500 | 
NPV of the project
| Year | CF | PVF@12% | Disc CF | 
| 0 | $ -1,00,00,000 | 1 | $ -1,00,00,000 | 
| 1 | $ 31,47,500 | 0.8929 | $ 28,10,268 | 
| 2 | $ 31,47,500 | 0.7972 | $ 25,09,168 | 
| 3 | $ 31,47,500 | 0.7118 | $ 22,40,328 | 
| 4 | $ 31,47,500 | 0.6355 | $ 20,00,293 | 
| 5 | $ 31,47,500 | 0.5674 | $ 17,85,976 | 
| 6 | $ 31,47,500 | 0.5066 | $ 15,94,621 | 
| 7 | $ 31,47,500 | 0.4523 | $ 14,23,769 | 
| 8 | $ 31,47,500 | 0.4039 | $ 12,71,222 | 
| NPV | $ 56,35,646 | 
NPV break even level of revenues
Let X be the revenues
| Sales | Cost | Depreciation | PBT | PAT | Depreciation | Cash Flow | 
| X | 3500000 | 1250000 | X-4750000 | 0.69X-3277500 | 1250000 | 0.69X-2027500 | 
12%, 8 year annuity factor
(0.69X-2027500) * 4.96763977 = Initial Investment
(0.69X-2027500) * 4.96763977 = 10000000
0.69X-2027500 = 10000000 / 4.96763977
0.69X-2027500 = 2013028
0.69X = 2013028 + 2027500
0.69X = 4040528
X = 4040528 / 0.69
X= 5855838
Therefore Net Present value Break-even level of revenues = 5855838
Pls do rate, if the answer is correct and comment, if any further assistance is required.