Calculate the amount of the annual loan repayment

Assignment Help Finance Basics
Reference no: EM13929931

Project 1:

Polycorp is considering an investment in new plant of $2.95 million. The project will be financed with a loan of $1,500,000 which will be repaid over the next five years in equal annual end of year instalments at a rate of 7.15 percent pa. Assume diminishing value depreciation over a five-year life, and no taxes. The projects cash flows before loan repayments and interest are shown in the table below. Cost of capital is 10.80% pa (the required rate of return on the project). A salvage value of $265,000 is expected at the end of year five and is included in the cash flows for year five below. Ignore taxes and inflation.

Year

Year One

Year Two

Year Three

Year Four

Year Five

Cash Inflow

1,080,000

820,000

805,000

1,005,000

1,045,000

You are required to calculate:

(1) The amount of the annual loan repayment and produce a repayment schedule.

(2) NPV of the project (to the nearest dollar)

(3) IRR of the project (as a percentage to two decimal places)

(4) AE, the annual equivalent for the project(AE or EAV) (to the nearest dollar)

(5) PB, the payback and discounted payback in years (to one decimal place)

(6) ARR, the accounting rate of return (gross and net) (to two decimal places)

(7) PI (present value index or profitability index) (to two decimal places)

(8) 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.

Project 2:

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.6 million. The machine has an estimated life of three years for accounting and taxation purposes. The contract will not continue beyond three years and the equipment's estimated salvage value at the end of three years is $198,000. The tax rate is 27 percent and is payable in the year after which profit is earned. An investment allowance of twenty percent on the outlay is available. The after tax cost of capital is 12.85%pa. Additional current assets of $65,000 are required immediately for working capital to support the project. Assume that this amount is recovered in full at the end of the three year life of the project. The new product will be charged $149,500 of allocated head office administration costs each year even though head office will not actually incur any extra costs to manage the project. This is in accordance with the firm's policy of allocating all corporate overhead costs to divisions. Extra marketing and administration cash outflows of $151,000 per year will be incurred by the Steel Division for the project. An amount of $149,000 has been spent on a pilot study and market research for the new product. The projections provided here are based on this work. Projected sales for the new product are 31,000 units at $152 per unit per year. Cash operating expenses are estimated to be 71 percent of sales (excludes marketing and administration, and head office items). Except for initial outlays, assume cash flows occur at the end of each year (unless otherwise stated). Assume diminishing value depreciation for tax purposes.

Required

(a) Construct a table showing your calculations of net cash flow after tax (NCFAT). Use the method shown in lectures and notes.

(b) Calculate the NPV. Is the project acceptable? Why or why not?

(c) Conduct a sensitivity analysis showing how sensitive the project is to operating expenses and to the cost of capital. Explain.

(d) Write a short report explaining your calculation of relevant net cash flows after tax, justifying your selection of cash flows. Be sure to state clearly any assumptions made (implicit and explicit).

Reference no: EM13929931

Questions Cloud

Equity used is from reinvested earnings : MM Entreprises stock trades for $52.50 per share. It is expected to pay $2.50 dividend at yearend, and the dividend is expected to grow at a constant rate of 5.50% a year. The before tac cost of debt is 7.50% and the tax rate is 40%. The target capit..
Explain how the cash short and over account required : Explain how the Cash Short and Over account required in this case will affect the income statement.
Which stock should my sister add to her portfolio : Your sister is considering to add one additional stock to a three stock portfolio, to form a four stock portfolio. The three stocks currently held all have b=1.0, and they are perfectly positively correlated with the market. However, stock A's standa..
Find the modified internal rate of return : Find the modified internal rate of return (MIRR) for the following series of future cash flows if the company is able to reinvest cash flows received from the project at an annual rate of 11.57 percent. The initial outlay is $496,600.
Calculate the amount of the annual loan repayment : Construct a table showing your calculations of net cash flow after tax (NCFAT) and calculate the NPV. Is the project acceptable? Why or why not?
The paleolithic artists did not just paint on the cave walls : The Paleolithic artists did not just paint on the cave walls, they created naturalism through each contour and shaping of an animal. The shading or modeling on a bison's belly was meant to create depth. The depth created can represent a pregnant anim..
Premerger information about bidding firm-target firm : Consider the following premerger information about a bidding firm (Firm B) and a target firm (Firm T). Assume that both firms have no debt outstanding. Firm B Firm T Shares outstanding 5,600 2,200 Price per share $ 45 $ 19 Firm B has estimated that t..
The process of understanding and specifying : 1. (TCO 3) The process of understanding and specifying what an information system should do is:         systems design.       systems construction.       systems analysis.
Carbon single bond : A carbon-carbon single bond has a bond energy of approximately 348kJ/mole

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd