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

You have just performed a scenario analysis on a project

You have just performed a scenario analysis on a project, with the following results: Best Case: with a 35% probability, you get an NPV of $77 Base Case: with a 55% probability, you get an NPV of $24 Worst Case: with a 1 ...

1 what are some impediments faced by communities wishing to

1. What are some impediments faced by communities wishing to perform hazard mitigation? 2. Name the primary federal mitigation programs, and explain how they serve to reduce hazard risk. 3. Do nonfederal mitigation progr ...

Name the industrywith this case a comparison is made

NAME THE INDUSTRY With this case, a comparison is made between three firms in different industries using net profit margin, total asset turnover and current ratio. 1. Apple Fiscal year 2010 ended September 25, 2010, and ...

Consider the following values noin1 28 million cap rate 75

Consider the following values. NOIn+1: $2.8 million. Cap rate: 7.5%. Brokerage commission: 3%. Remaining mortgage balance: $12 million. Remaining book value: $14 million. Total depreciation taken: $4.9 million. Recapture ...

Evaluate visuals used for a presentationattend a business

Evaluate visuals used for a presentation. Attend a business meeting, a city council meeting, a student council meeting, a business conference, an executive lecture presentation, or some other event where oral presentatio ...

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 ...

1 why is the income approach to value often difficult to

1. Why is the income approach to value often difficult to use on a single-family residential appraisal? 2. What are the differences between the cost and sales comparison approaches to appraising property? 3. What are the ...

1 what makes a good theory why are theories so important in

1. What makes a good theory? Why are theories so important in behavioral research? 2. What makes a theory falsifiable? What makes a theory tautological? 3. What is a research hypothesis? Why are research hypotheses, rath ...

Capital investment analysisbramer corporations controller

Capital Investment Analysis Bramer Corporation's controller, Mara, was asked to prepare a capital investment analysis for a robot-guided aluminum window machine. This machine would automate the entire window-casing manuf ...

A scheme for the removal of h2s from a gas stream by

A scheme for the removal of H 2 S from a gas stream by scrubbing with water at 293 K and 1.013×10 5  Pa is being considered. The liquid will initially contain 3.7 mol % H 2 S. It is desired that the exiting gas stream co ...

  • 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