Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

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

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

Question Description

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?

Complete this question by entering your answers in the tabs below.

  • 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.
  2. Adjusted accounting profits.
  3. Add back depreciation tax shield.

Methods of CalculationOperating Cash Flow

i.Dollars in Minus Dollars Out____________

ii.Adjusted Accounting profits_______________

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

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: School Assignment only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by School Assignment are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. School Assignment is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At School Assignment, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.