Develop spread sheet model-net present value

Assignment Help Financial Management
Reference no: EM132037497

For a New product, sales volume in the first year is estimated to be 80,000 units and is projected to grow at a rate of 4% per year. the selling price is $12 and will increase by $0.50 each year. Per -unit variable costs are $3, and annual fixed costs are $400000. Per-unit costs are expected to increase 5% per year. Fixed costs are expected to increase 8% per year. develop a spread sheet model to calculate the net present value of profit over a 3- year period, assuming a 4% discount rate.

Reference no: EM132037497

Questions Cloud

What is the firm cost of capital : What is the firm’s cost of capital if their capital structure consists of 60% equity and 40% bank loans?
What is the margin in my account : What is the margin in my account when I first purchase the stock?
Calculate sensitivity of ocf to changes in quantity sold : Calculate the sensitivity of the OCF to changes in the quantity sold.
What is the best estimate of these bonds remaining life : What is the best estimate of these bonds’ remaining life?
Develop spread sheet model-net present value : Develop a spread sheet model to calculate the net present value of profit over a 3- year period, assuming a 4% discount rate.
Decisions in comparision to individual decisions : What are some strengths and weknesses of group decisions in comparision to individual decisions.
Examples of exemplary marketing : His talk will include examples of exemplary marketing. what you found the most interesting in Dr. Kotler's marketing talk?
What is the company pretax cost of debt : What is the company’s pretax cost of debt? If the tax rate is 35 percent, what is the aftertax cost of debt?
Skills or behaviors relate to their mbti personality type : How do those traits, skills or behaviors relate to their MBTi personality type?

Reviews

Write a Review

Financial Management Questions & Answers

  In the real world is it possible to construct a portfolio

In the real world, is it possible to construct a portfolio of stocks that has an expected return equal to the risk-free rate? Provide examples.

  By what percentage did your net income change

By what percentage did your net income change? What are your current profit margin and your pro forma profit margin?

  Involving business relationships

Barney and Marilyn have been married for six months. They engage in negotiations consistently as a way to improve their understanding of each other and to build a loving relationship. How does this "relationship" negotiation differ from the negoti..

  Affect global logistics and supply chain decisions

In your opinion, what are the major sources of uncertainty (financial and non-financial) that can affect global logistics and supply chain decisions in auto, electronics, food and retail industries? How can those be mitigated?

  Calculate the basic earnings power-dividend payout

Maggie’s Skunk Removal Corp.’s 2015 income statement listed net sales of $14.1 million, gross profit of $9.00 million, EBIT of $7.2 million, net income available to common stockholders of $4.8 million, and common stock dividends of $2.8 million. Calc..

  Questionthree months after having completed the supply and

questionthree months after having completed the supply and commissioning of capital equipment to approval of a public

  Would they be able to take the vacation

Selma and Troy are planning to take a second honeymoon in two years. They estimate that the cost will be roughly $7,985.74.

  What is the estimated 2018 value of ges share in pivotal

What is the estimated 2018 value of GE's share in Pivotal?- What is GE's implied cost of capital that justified $ 105 M investment?

  All the equity used is from retained earnings

What is the company's WACC if all the equity used is from retained earnings?

  Series of cash flows

An asset promes the following series of cash flows: 2,300 in year one,3,200 in year two, 3,600 in year three. after year 3 the cash flows are expected to grow at a constant rate of 4.8% in perpetuity. The RRR on the asset ins 12.60%. Calculate the va..

  What would the bond equivalent yield

Teresa is looking at Treasury bill data from yesterday’s Wall Street Journal. She observes an “ask” discount yield of 6.58%, on T-bills with 124 days left to maturity. What would the bond equivalent yield have been, based on the asked prices?

  Use no-load or load funds and closed-end or open-end funds

You should not only talk about the fund types in which you would invest but also whether you would use no-load or load funds and closed-end or open-end funds.

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