Discounted cash flow model to determine the NPV

Assignment Help Financial Management
Reference no: EM131020343

A five-year software development project is forecast to have net cash inflows of $15,000, $20, 000, $25,000, $30,000, and $50,000 in the next five years. It will cost $80,000 to implement the project, payable at the beginning of the project. There is an assumed inflation rate of .02 each of the five years for this project. If the required rate of return is .05, construct a discounted cash flow model to determine the NPV. Use the concepts found in Mantel, Chapter 1, Section 1.5 and Excel to create the formulas needed to calculate the NPV. Assume the inflows all occur at the end of the year.

Reference no: EM131020343

Questions Cloud

What annual rate of return have you earned : You have an investment account that started with $4000 10 years ago and which now has grown to $12000. What annual rate of return have you earned (you have made no additional contributions to the account)?
Should she ask for an extension on her assignment : Carly wants DressUp to increase its popularity and become a topnotch company among college trendsetters.  What should she do and why? Should she quit her internship and drop the class
Total debt obligations with book and market values : Finance balance sheet: KneeMan Markup Company has total debt obligations with book and market values equal to $30 million and $28 million, respectively. It also has total equity with book and market values equal to $20 million and $70 million, respec..
Case: the case of the reference request : Case: The Case of the Reference Request. A former employee who was fired due to poor quality work, absences, and lateness related to a drinking problem, informs you that she has applied for a position at another company and has already given your..
Discounted cash flow model to determine the NPV : A five-year software development project is forecast to have net cash inflows of $15,000, $20, 000, $25,000, $30,000, and $50,000 in the next five years. It will cost $80,000 to implement the project, payable at the beginning of the project. If the r..
Farm will require an initial investment : Archer Daniels Midland Company is considering buying a new farm that it plans to operate for 10 years. The farm will require an initial investment of $12.10 million. This investment will consist of $2.90 million for land and $9.20 million for trucks ..
Should eric accept the offer : Eric, a second-semester senior, is looking for a job. Anxious about finding work in the worst economy in decades, he sends out scores of resumes for a wide variety of positions. Should Eric accept the offer
Are instagram users reasonable in expecting their postings : Why are Instagram users making such a fuss about the revised privacy policy if they are gaining so much personal satisfaction or business from a service that is free? Are Instagram users reasonable in expecting that their postings be kept private
First annual retirement payment : Mel plans to save 10,200 dollars per year in his retirement account for 6 years. His first savings contribution to his account is expected in 1 year. Mel expects to earn 7.79 percent per year in his account. He plans to retire in 6 years. In retireme..

Reviews

Write a Review

 

Financial Management Questions & Answers

  Expects output levels to remain steady in the future

A bicycle manufacturer currently produces 300,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $2 a chain. The plant manager believes that it would be cheaper to make the..

  Net income available to common stockholder plus depreciation

Assume NEWC has an investment opportunity (similar to the air bag opportunity in Other People's Money).The firm can spend $325 Million on refurbishing its wire and cable plant to develop a product that will be sold in packets or units of twenty. Assu..

  Calculate the after-tax cost of debt-cost of preferred stock

Calculation of individual costs and WACC Dillon Labs has asked its financial manager to measure the cost of each specific type of capital as well as the weighted average cost of capital. The weighted average cost is to be measured by using the follow..

  Risk for high medical expenditures

The law now gives a worker who becomes unemployed the right to buy continuing health insurance coverage after leaving the company. Why might it be rational for a factory worker who loses his or her job to give up this legal right to purchase coverage..

  Collection of accounts receivable and developing budgets

The controller in a hospital is usually responsible for which of the following activities (choose all that apply): A. Collection of accounts receivable B. Developing budgets C. Filing Medicare cost reports D. Arranging hospital loans

  What is the repo rate

The European Cental Bank engages in a term repo operation with Banking4EU. Specifically, the central bank buys 150mn Euros of bonds which Banking4EU agrees to repurchase for $151mn in three months' time. What is the repo rate?

  What percent would its roe increase

Tapley Dental Supply Company has the following data: Net income: $240 Sales: $10,000 Total assets: $6,000 Debt ratio: 75% TIE ratio: 2.0 Current ratio: 1.2 If Tapley could streamline operations, cut operating costs, and raise net income to $520, with..

  How much must she pay to retire the mortgage

A borrower took out a 30-year fixed-rate mortgage of $2,250,000 at a 6.2% annual rate with monthly payments. After five years, she wishes to pay off the remaining balance. Interest rates have by then fallen to 4.0%. How much must she pay to retire th..

  Firms increased-decreased or remained unchanged

Change in Cost of Capital. Assume that Naperville Co. will use equity to finance a project in Switzerland, while Lombard Co. will rely on a dollar-denominated loan to finance a project in Switzerland, and Addison Co. will rely on a Swiss franc-denomi..

  Stand-alone risk-diversifiable risk and market risk

Briefly but carefully distinguish between Stand-alone risk, diversifiable risk, and market risk. Of the three measures, which one is most relevant for stock valuation? Why?

  Taxable income-tax liability and tax refund or tax owed

Mary Watson is 24 years old and single lives in an apartment and has no dependents. Last year she earned 45,000 as a sales assistant for focus to business analytics: $3910 of her wages was withheld for federal income taxes. In addition, she had inter..

  Determine net present value of the investment

The added production would require an increase in working capital in the form of stocks, valued at cost, of £300,000. The tax rate is 20 per cent and the required rate of return is 18 percent. Determine the net present value of the investment, sp..

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