Question: 8-14 A project is being considered that requires $1,000,000 for fixed-capital investment and $100,000 for working capital. The fixed capital is depreciated on a straight-line

8-14 A project is being considered that requires $1,000,000 for fixed-capital investment and $100,000 for working capital. The fixed capital is depreciated on a straight-line basis to a book value of zero at the end of the fifth year. The annual revenue in those 5 years is $500,000. The total product cost not including depreciation is $100,000 annually. The dis- count rate is 10 percent, and the income taxation rate is 35 percent. Develop a spreadsheet that shows the annual cash flow, the discounted cash flow, and the net present worth for each year. Treat the investments as occurring in a lump sum at zero time. The revenues and expenses occur continuously and utilize continuous compounding. Now assume an inflation rate of 5 percent on both the revenues and the expenses. Again, develop another spreadsheet that shows the annual cash flow, the discounted cash flow, and the net present worth for each year
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
