Question

In: Finance

Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...

Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Kingston Corp. is considering a new machine that requires an initial investment of $520,000 installed, and has a useful life of 8 years. The expected annual after-tax cash flows for the machine are $76,000 during the first 3 years, $87,000 during years 4 through 6 and $92,000 during the last two years.

(i) Develop the timeline (linear representation of the timing of cash flows)

(ii) Calculate the Internal Rate of Return (IRR)

(iii) Calculate the Net Present Value (NPV) at the following required rates of return: (a) 3% (b) 4% (c) 8% (d)9%

(iv) Using IRR and NPV criterion, comment if the project should be accepted or rejected at the following required rates of return: (a) 3% (b) 4% (c) 8% (d) 9%

(v) Plot the Net Present Value profile (NPV on Y axis and rates of return on X-axis).

Solutions

Expert Solution

i) Time line for cash flows:

ii) IRR = 5.87% (using the excel function for cash flows)

iii) The NPV values at diffrent required rate of return are:

a 3% $67,611.00
b 4% $42,675.84
c 8% -$42,771.68
d 9% -$61,070.48

Workings:

Year Cash flows 3% PV of cash flows 4% PV of cash flows 8% PV of cash flows 9% PV of cash flows
0 -$5,20,000 $1 -$5,20,000 $1 -$5,20,000 $1 -$5,20,000 $1 -$5,20,000
1 $76,000 $0.971 $73,786 $0.962 $73,077 $0.926 $70,370 $0.917 $69,725
2 $76,000 $0.943 $71,637 $0.925 $70,266 $0.857 $65,158 $0.842 $63,968
3 $76,000 $0.915 $69,551 $0.889 $67,564 $0.794 $60,331 $0.772 $58,686
4 $87,000 $0.888 $77,298 $0.855 $74,368 $0.735 $63,948 $0.708 $61,633
5 $87,000 $0.863 $75,047 $0.822 $71,508 $0.681 $59,211 $0.650 $56,544
6 $87,000 $0.837 $72,861 $0.790 $68,757 $0.630 $54,825 $0.596 $51,875
7 $92,000 $0.813 $74,804 $0.760 $69,912 $0.583 $53,681 $0.547 $50,327
8 $92,000 $0.789 $72,626 $0.731 $67,223 $0.540 $49,705 $0.502 $46,172
NPV $67,611.00 $42,675.84 -$42,771.68 -$61,070.48

iv) Using the NPV and IRR criteria, a project should be accepted if NPV is positive and IRR is more than the rate of return.

a 3% $67,611.00 Accept
b 4% $42,675.84 Accept
c 8% -$42,771.68 Reject
d 9% -$61,070.48 Reject

v) NPV profile


Related Solutions

Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (i)...
Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel)...
Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel) to solve the problem related to the cost of capital. You are required to show the following 3 steps for the problem. (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Submit all answers as percentages and round to two decimal places. Problem: Cosa Nostra...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided capital budgeting problem (sample questions and solutions are provided for guidance). Problem: Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years....
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. A company’s stock...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve related to...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve related to the risk and return, stocks and bonds valuation. You are required to show the following 3 steps for each problem (sample questions and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. PROBLEM: Consider a 10 year bond with face...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (iii) Calculate...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (i) Develop...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places. Lee Airlines plans to issue 25-year bonds with a par value of...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places Fisheye Inc. is investing in a new project costing $20 million. It...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the following investments. Investment A B Initial Investment $                8,500.00 $      9,500.00 End of Year Income 1 $                2,500.00 $      2,000.00 2 $                2,500.00 $      2,500.00 3 $                2,500.00 $      3,000.00 4 $                2,500.00 $      3,500.00 5 $                2,500.00 $      4,000.00
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT