Reference no: EM131623901
Project 1: Calculations must be done in Excel
Polycorp is considering an investment in new plant of $3.25 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.23 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 shown in the table below. Cost of capital is 12.15% pa (the required rate of return on the project). A salvage value of $215,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
925,000
885,000
895,000
945,000
935,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.
Compute both basic and diluted earnings per share
: The Indigo Corporation issued 10-year, $4,890,000 par, Compute both basic and diluted earnings per share
|
What supervisory trait do you most relate to and why
: What supervisory trait do you most relate to and why? Why do supervisors fail if they are using a "textbook" technique?
|
Calculate the combined tax bill that they would pay
: Suppose Kim and Kanye both earn $70,000 (so their combined income is $140,000). Using the tax bracket information in Table.
|
Prepare the entry to record exercise of conversion option
: On January 1, 2016, when its $30 par value common stock was selling for $80 per share, Prepare the entry to record the exercise of the conversion option
|
Calculations must be done in excel
: Polycorp is considering an investment in new plant of $3.25 million. The project will be partially financed with a loan of $2,000,000
|
Define federal reserve in stabilizing the current economy
: Evaluate the role and the effectiveness of the Federal Reserve in stabilizing the current economy
|
Discuss about the professional investment management
: Briefly define and differentiate among the following investments. Which offer fixed returns? Which are derivative securities?
|
Increase for this item between the two time periods
: The average cost of those same motor vehicles is now $24,000. What was the rate of increase for this item between the two time periods?
|
Prepare journal entries for each transaction
: The trial balance of My Motor, Inc. on March 1, 20XX, lists the entity's assets, Prepare journal entries for each transaction
|