Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

1) Excel inc, is considering the investment in latest plant= $3 million. Project will be financed with the loan= $2,000,000 which will be repaid over next five years in equivalent annual end of year instalments at the rate of 6.5 percent pa. Suppose straight-line depreciation over the five-year life, and no taxes. Projects cash flows before loan repayments and interest are given in the table below. Cost of capital= 13.35% pa (necessary rate of return on the project). Salvage value= $200,000 is expected at the ending of year five and is included in = cash flows for year five below. Avoid taxes and inflation.

Year                 Cash Inflow
Year One            850,000
Year Two            900,000
Year Three          800,000
Year Four           900,000
Year Five            950,000

You are needed to compute:

(i) The annual loan repayment and a repayment schedule.

(ii) NPV of the project

(iii) the IRR of the project

(iv) AE, annual equal for the project(AE or EAV)

(v) PB, the payback in years (to one decimal place)

(vi) ARR, the accounting rate of return (gross)

(vii) PI (present value index or profitability index)

(viii) Is project acceptable? You should provide the decision for each of methods in parts (ii) to (vii). describe why or why not (give full description)?

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M914208

Have any Question? 


Related Questions in Basic Finance

1 what types of risks should shareholder wealth-maximizing

1. What types of risks should shareholder wealth-maximizing managers seek to offset in a firm they are managing? Why? 2. How can the acquisition of additional information be an effective tool of risk management? Give an ...

A researcher was interested in the effects of weather on

A researcher was interested in the effects of weather on cognitive performance. He tested participants on either sunny or cloudy days, and obtained the following scores on a 10-item test of cognitive performance. Using t ...

Following the end of world war ii in 1945 the reichsmark

Following the end of World War II in 1945, the Reichsmark, the German currency, lost so much value that a barter economy arose. During this period, many Germans used U.S. cigarettes as currency. Why might cigarettes, rat ...

Borachera is a major spanish wine wholesaler currently

Borachera is a major Spanish wine wholesaler currently operating two CDCs in Salamanca and Albacete, and a number of RDCs all over the Iberian peninsula. In order to reduce its overall logistics cost, the company wishes ...

What is the excess burden of taxation why is there an

What is the excess burden of taxation? why is there an excess burden, and what factors affect the size of the excess burden for a specific tax? if several goods are to be tax, how should the taxes be distributed to minim ...

A building owner is evaluating the following four

A building owner is evaluating the following four alternatives for leasing space in an office building for the next five years. Write a two-three page paper and prepare an Excel spreadsheet evaluating each of the four di ...

1 based on the cash flow statement and personal balance

1. Based on the cash flow statement and personal balance sheet, do the Sampsons have adequate liquidity to cover their recurring cash flows and planned monthly savings in the long-run? If not, what level of savings shoul ...

1 how has transportation cost as a percentage of total

1. How has transportation cost, as a percentage of total logistics cost, tracked since 1980? 2. Describe the logistics value proposition. Be specific regarding specific customer accommodation and cost. 3. Describe the fu ...

Can someone help provide the steps and solution to this

Can someone help provide the steps and solution to this problem. X-treme Vitamin Company is considering two investments, both of which cost $10,000. The cash flows are as follows: Year Project A Project B 1.............. ...

Briefly describe each of the following funds transfer

Briefly describe each of the following funds transfer mechanisms: a. Depository transfer check (DTC) b. Automated clearinghouse (ACH) debit transfer c. Wire transfer Why are wire transfers typically used only for high-do ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen