# FIN 571 University of Phoenix Week 3 Net Cashflows and Cumulative PV Worksheet

1.

A new furnace for your small factory will cost \$43,000 and a year to install, will require ongoing maintenance expenditures of \$4,000 a year. But it is far more fuel-efficient than your old furnace and will reduce your consumption of heating oil by 4,000 gallons per year. Heating oil this year will cost \$3 a gallon; the price per gallon is expected to increase by \$0.50 a year for the next 3 years and then to stabilize for the foreseeable future. The furnace will last for 20 years, at which point it will need to be replaced and will have no salvage value. The discount rate is 8%.

a. What is the net present value of the investment in the furnace? (Do not round intermediate calculations. Round your answer to the nearest whole dollar.)

b. What is the IRR? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)

c. What is the payback period? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

d. What is the equivalent annual cost of the furnace? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

e. What is the equivalent annual savings derived from the furnace? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

f. Compare the PV of the difference between the equivalent annual cost and savings to your answer to part (a). Are the two measures the same or is one larger?

a.NPV_________

b.IRR________%

c.Cumulative cash flows are positive in:_____

d.Equivalent annual cost________

e.Equivalent annual savings__________

f.Are the two measures the same or is one larger?_________

2.

The following are the cash flows of two independent projects:

 Year Project A Project B 0 \$ (290 ) \$ (290 ) 1 170 190 2 170 190 3 170 190 4 170

a. If the opportunity cost of capital is 11%, calculate the NPV for both projects. (Do not round intermediate calculations. Round your answers to 2 decimal places.)

b. Which of these projects is worth pursuing?

Project A

Project B

Both

Neither

3.

Find the interest rate implied by the following combinations of present and future values: (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. Leave no cells blank – be certain to enter “0” wherever required.)

PresentValueYearsFuture ValueInterest Rate

\$41012825%

1885289%

3108310%

4.

Johnny’s Lunches is considering purchasing a new, energy-efficient grill. The grill will cost \$44,000 and will be depreciated straight-line over 3 years. It will be sold for scrap metal after 5 years for \$11,000. The grill will have no effect on revenues but will save Johnny’s \$22,000 in energy expenses. The tax rate is 30%.

Required:

a. What are the operating cash flows in each year?
b. What are the total cash flows in each year?
c. Assuming the discount rate is 11%, calculate the net present value (NPV) of the cash flow stream. Should the grill be purchased?

• Required A
• Required B
• Required C

What are the operating cash flows in each year? (Do not round intermediate calculations. Round your answers to 2 decimal places.)

 Year Operating Cash Flows 1 2 3

What are the total cash flows in each year? (Negative amounts should be indicated with a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.)

 Time Total Cash Flows 0 1 2 3

Assuming the discount rate is 11%, calculate the net present value (NPV) of the cash flow stream. Should the grill be purchased? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

 NPV of cash flow stream Should the grill be purchased?

5.

Old Time Savings Bank pays 3% interest on its savings accounts. If you deposit \$3,000 in the bank and leave it there: (Do not round intermediate calculations. Round your answers to 2 decimal places.)

a. How much interest will you earn in the first year?

b. How much interest will you earn in the second year?

c. How much interest will you earn in the 10th year?

6.

You can buy property today for \$4.0 million and sell it in 6 years for \$5.0 million. (You earn no rental income on the property.)

a. If the interest rate is 9%, what is the present value of the sales price? (Do not round intermediate calculations. Enter your answer in millions rounded to 3 decimal places.)

b. Is the property investment attractive to you?

c-1. What is the present value of the future cash flows, if you also could earn \$300,000 per year rent on the property? The rent is paid at the end of each year. (Do not round intermediate calculations. Enter your answer in millions rounded to 3 decimal places.)

c-2. Is the property investment attractive to you now?

a.Present valuemillion

b.Is the property investment attractive to you?

c-1.Present valuemillion

c-2.Is the property investment attractive to you now?

7.

Bottoms Up Diaper Service is considering the purchase of a new industrial washer. It can purchase the washer for \$8,400 and sell its old washer for \$2,400. The new washer will last for 6 years and save \$2,400 a year in expenses. The opportunity cost of capital is 19%, and the firm’s tax rate is 21%.

a. If the firm uses straight-line depreciation over a 6-year life, what are the cash flows of the project in years 0 to 6? The new washer will have zero salvage value after 6 years, and the old washer is fully depreciated. (Negative amounts should be indicated by a minus sign.)

b. What is project NPV? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

c. What is NPV if the firm investment is entitled to immediate 100% bonus depreciation? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

a.Annual operating cash flow in year 0

Annual operating cash flow in years 1 to 6

b.NPV

c.NPV

8.

Your landscaping company can lease a truck for \$7,100 a year (paid at year-end) for 7 years. It can instead buy the truck for \$38,000. The truck will be valueless after 7 years. The interest rate your company can earn on its funds is 8%.

a. What is the present value of the cost of leasing? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

b. Is it cheaper to buy or lease?

c. What is the present value of the cost of leasing if the lease payments are an annuity due, so the first payment comes immediately? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

d. Is it now cheaper to buy or lease?

 a. Present value of lease b. Is it cheaper to buy or lease? c. Present value of lease d. Is it now cheaper to buy or lease?

9.

Compute the future value of a \$105 cash flow for the following combinations of rates and times. (Do not round intermediate calculations. Round your answers to 2 decimal places.)

a. r = 8%; t = 10 years

b. r = 8%; t = 20 years

c. r = 4%; t = 10 years

d. r = 4%; t = 20 years

 Future Value a. b. c. d.

10.

Talia’s Tutus bought a new sewing machine for \$90,000 that will be depreciated over 5 years using double-declining-balance depreciation with a switch to straight-line.

Required:

a. Find the depreciation charge each year.

b. If the sewing machine is sold after 4 years for \$26,000, what will be the after-tax proceeds on the sale if the firm’s tax bracket is 35%?

Find the depreciation charge each year.

 Year Depreciation 1 2 3 4 5

If the sewing machine is sold after 4 years for \$26,000, what will be the after-tax proceeds on the sale if the firm’s tax bracket is 35%?

 After-tax proceeds

11.

a. What is the present value of a 3-year annuity of \$210 if the discount rate is 7%? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

b. What is the present value of the annuity in (a) if you have to wait an additional year for the first payment? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)

12.

The following are the cash flows of two projects:

 Year Project A Project B 0 \$ (380 ) \$ (380 ) 1 210 280 2 210 280 3 210 280 4 210

a. Calculate the NPV for both projects if the discount rate is 11%. (Do not round intermediate calculations. Round your answers to 2 decimal places.)

 Project NPV Project A Project B

b. Suppose that you can choose only one of these projects. Which would you choose?

Project B

Project A

Neither

13.

If you insulate your office for \$12,000, you will save \$1,200 a year in heating expenses. These savings will last forever.

a. What is the NPV of the investment when the cost of capital is 5%? 10%?

Cost of CapitalNPV

5%____________

10% ________________

b. What is the IRR of the investment? (Enter your answer as a whole percent.)

 IRR %

c. What is the payback period on this investment?

Payback period______________years

14.

The owner of a bicycle repair shop forecasts revenues of \$224,000 a year. Variable costs will be \$66,000, and rental costs for the shop are \$46,000 a year. Depreciation on the repair tools will be \$26,000.

a. Prepare an income statement for the shop based on these estimates. The tax rate is 20%.

 INCOME STATEMENT

b. Calculate the operating cash flow for the repair shop using the three methods given below:

Now calculate the operating cash flow.

1. Dollars in minus dollars out.
3. Add back depreciation tax shield.

Methods of CalculationOperating Cash Flow

i.Dollars in Minus Dollars Out____________

iii.After tax Operating Cash flow__________________

15.

A factory costs \$410,000. You forecast that it will produce cash inflows of \$125,000 in year 1, \$185,000 in year 2, and \$310,000 in year 3. The discount rate is 11%.

a. What is the value of the factory? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

b. Is the factory a good investment?

Yes

No

Price (USD)
\$