Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hint to #2: Is there an answer to Discounted Payback? Why or why not? A B C D E F G H Problem 10.33 Comprehensive

image text in transcribedimage text in transcribed

Hint to #2: Is there an answer to Discounted Payback? Why or why not?

image text in transcribedimage text in transcribed
A B C D E F G H Problem 10.33 Comprehensive Skywards Inc., an airline caterer, is purchasing refrigerated trucks at a total cost of$3.25 million. After-tax net income from this investment is expected to be $750,000 for the next five years. Annual depreciation expense was $650,000. The company's cost of capital is 17 percent. Hint: Lking the information given in the problem, compute the cash flows for each year of the project's life. Cost: Project Life (years): Discount Rate: Year Net Income Depreciation Project Cash Flows 12 13 0 a. What is the discounted payback period? Hint: Calculate the cumulative present value cash flow for each year of the project's life and compute the project's discounted payback period. Project PVCF@ Cumulative Cumulative Year Cash Flow PVCE Periods Discounted Payback Period: b. What is the NPV on this investment? Hint: Calculate the net present value using an equation and then use the NIV function, NPVrate,valuel,value2, ..), to compute the net present value of the project. NPV (Equation): NPV (Excel Function): c. Calculate the IRR. Hint: Use the IRR function, IRR(values.guess), to compute the internal rate of return of the project. IRR Problem 1 Problem 2B C D E F H Problem 1031 Comprehensive Primus Corp is planning to convert an existing warehouse into a new plant that will increase its production capacity by 43 percent. The cost of this project 3 will be $3,125,000. It will result in additional cash flows of $1,875,000 for the next eight years. The company uses a discount rate of 12 percent. Hint: Recognize that the project cash flows are in the form of an annuity and input a simple equation for calculating the payback period. Then calculate the payback period. Calculate the net present value using an equation and then use the NPV function, NPV(rate, value I, value?, -), to compute the net present value of the project Use the IRR function, IRR( values guess), to compute the internal rate of return of the project. Discount Rate: Year Project Cash Flows 3 4 6 a. What is the payback period? Payback Period ( Annuity): Discount Rate: 12 00% Project Cash Flame Cummlathe Cash Flax Cumulative Perkads 2 4 Payback Period: h. What is the NPV for this project? NPV (Equation): NPV (Excel Function): c. What is the IRR? IRR: Problem 1 Problem 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Financial Management For Public Health And Not For Profit Organizations

Authors: Steven A. Finkler

2nd Edition

0131471988, 978-0131471986

More Books

Students also viewed these Finance questions

Question

=+b) Which model do you prefer? Explain briefly. Section 18.4

Answered: 1 week ago