Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions