Question

In: Finance

Project 1 Calculations must be done in Excel Polycorp is considering an investment in new plant...

Project 1 Calculations must be done in Excel

Polycorp is considering an investment in new plant of $3 million. The project will be partially financed by a loan of $2 million, which will be repaid over five years in equal annual end of year instalments at a rate of 6.5 percent pa. The rest of the project will be financed by equity. Assume straight-line depreciation over a five-year life, and no taxes. The project’s cash flows before loan repayments and interest are in the table below. Cost of capital is 12.30% pa (the required rate of return on the project). A salvage value of $190,000 is expected at the end of year five and is not included in the cash flows for year five below.

Year

Year One

Year Two

Year Three

Year Four

Year Five

Net Flows Cash

850,000

970,000

881,500

934,530

945,000

You are required to calculate:

  1. PB, the payback and discounted payback in years (to one decimal place)
  2. ARR, the accounting rate of return (gross and net) (to two decimal places)
  3. PI (present value index or profitability index) (to two decimal places)
  4. Is the project acceptable? You must provide a decision or explanation for each of the methods in parts (2) to (7). Why or why not (provide a full explanation)? Also, a brief explanation of your treatment of Salvage Value and Loan Repayments is required.

Solutions

Expert Solution

The project is acceptable as it has a positive NPV and high Profitability Index and its IRR(34%) is way over required rate of return.

Salvage Value is a cashflow at the end of the year and is usually taxable. So are the interest payments, but as tax rate is not provided we can ignore both the tax payment and tax savings.

Good Luck


Related Solutions

Calculations must be done in Excel Polycorp is considering an investment in new plant of $3.2...
Calculations must be done in Excel Polycorp is considering an investment in new plant of $3.2 million. The project will be partially financed with a loan of $2,000,000 which will be repaid over the next five years in equal annual end of year instalments at a rate of 6.20 percent pa. The rest of the project will be financed by equity. Assume straight-line depreciation over a five-year life, and no taxes. The project’s cash flows before loan repayments and interest...
Project 1 Calculations must be done in Excel As the financial advisor to Upmarket Car Rentals...
Project 1 Calculations must be done in Excel As the financial advisor to Upmarket Car Rentals you are evaluating the following types of cars to add to the fleet: - 1. Speedster: - A sporty convertible with a cost of $120,000 and a useful life of 4 years. It will produce rental income of $80,000 per year and operating costs of $15,000 per year. A major service is required after 2 years costing $20,000. A salvage value of $30,000 is...
Project 1 Calculations must be done in Excel Fergy Smith, the financial advisor to Uncovered Car...
Project 1 Calculations must be done in Excel Fergy Smith, the financial advisor to Uncovered Car Rentals is evaluating the following types of cars to add to the fleet:- Topless:- A sporty convertible with a cost of $100,000 and a useful life of 5 years. It will produce rental income of $60,000 per year and operating costs of $10,000 per year. A major service is required after 3 years costing $15,000. A salvage value of $25,000 is expected after 5...
Project 2 Calculations must be done in Excel – You must create your own spreadsheet (do...
Project 2 Calculations must be done in Excel – You must create your own spreadsheet (do not copy and paste someone else’s). This question should be done using Method 1 as outlined in lecture 6 (i.e. Tax Effects, then Cash Flows then NPV) As the financial advisor to All Star Manufacturing you are evaluating the following new investment in a manufacturing project: - The project has a useful life of 12 years. Land costs $6m and is estimated to have...
Calculations must be done in Excel – You must create your own spreadsheet do not copy...
Calculations must be done in Excel – You must create your own spreadsheet do not copy and paste someone else’s. Polycorp Limited Steel Division is considering a proposal to purchase a new machine to manufacture a new product for a potential three year contract. The new machine will cost $1.9 million. The machine has an estimated life of three years for accounting and taxation purposes. Installation will cost a further $120,000. The contract will not continue beyond three years and...
Calculations must be done in Excel - Using the capital budgeting method of; Tax Effects, then...
Calculations must be done in Excel - Using the capital budgeting method of; Tax Effects, then Cash flows, then NPV. As the financial advisor to All Star Manufacturing you are evaluating the following new investment in a manufacturing project: - The project has a useful life of 12 years. Land costs $6m and is estimated to have a resale value of $10m at the completion of the project. Buildings cost $5m, with allowable depreciation of 10% pa reducing balance and...
Calculations must be done in Excel As the financial advisor to Upmarket Car Rentals you are...
Calculations must be done in Excel As the financial advisor to Upmarket Car Rentals you are evaluating the following types of cars to add to the fleet: - Speedster: - A sporty convertible with a cost of $120,000 and a useful life of 4 years. It will produce rental income of $80,000 per year and operating costs of $15,000 per year. A major service is required after 2 years costing $20,000. A salvage value of $30,000 is expected after 4...
NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS. An ARM for 100,000 is made at the...
NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS. An ARM for 100,000 is made at the time when the expected start rate is 5 percent. The Loan will be made with a teaser rate of 2 percent for the first year, after which the rate will be reset. The loan is fully amortizing, has a maturity of 25 years, and payments will be made monthly. a. What will be the payments during the first year? b. Assuming that the reset...
NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS. An investor has $60,000 to invest in a...
NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS. An investor has $60,000 to invest in a 280,000 property. He can obtain either a $220,000 loan at 9.5 percent for 20 years or a $180,000 loan at 9 percent for 20 years and second mortgage for $40,000 at 13 percent for 20 years. All loans require monthly payments and are fully amortizing a. Which alternative should the borrower choose, assuming he will own the property for the full loan term? b....
Polycorp Steel Division is considering a proposal to purchase a new machine to produce a new...
Polycorp Steel Division is considering a proposal to purchase a new machine to produce a new product for a three-year contract. The new machine will cost $1.83 million. The machine has an estimated life of 3 years for accounting and taxation purposes. Installation will cost a further $90,000. The contract will not continue beyond three years and the equipment has an estimated salvage value at the end of three years of $300,000. The tax rate is 29 percent and is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT