Calculate the net present value of profit

Assignment Help Finance Basics
Reference no: EM13833487

For a new product, sales volume in the first year is estimated to be 100,000 units and is projected to grow at a rate of 7% per year. The selling price is $10 and wil increase by $0.50 each year. Per-unit variable costs are $3, and annual fixed costs are $200,000. Per-unit costs are expected to increase 5% per year. Fixed costs are expected to increase 10% per year. Develop a spreadsheet model to calculate the net present value of profit over a 3-year period, assuming a 7% discount rate. 

Reference no: EM13833487

Questions Cloud

Compared with perfect competition-quantity produced : Compared with perfect competition, quantity produced in monopolistic competition is inefficient as price is higher than marginal cost (i.e. allocative inefficiency). Why do some economists argue that even if price is higher than marginal cost, it doe..
Key difference between accountants and economists : A key difference between accountants and economists is their different treatment of the cost of capital. Does this cause an accountant’s estimate of total costs to be higher or lower than an economists estimate? Explain.
Charged by the thieves : A thief steals your credit card and racks up $2,000 worth of charges. You notify your credit card company as soon as you realize the card is missing, but you must pay off the $2,000 bill charged by the thieves.
The federal government : Sales taxes are not deducted from your paycheck by the federal government.
Calculate the net present value of profit : For a new product, sales volume in the first year is estimated to be 100,000 units and is projected to grow at a rate of 7% per year. The selling price is $10 and wil increase by $0.50 each year. Develop a spreadsheet model to calculate the net prese..
Family violence in same sex relationships is not considered : Family violence in same sex relationships is not considered to be an offence undercurrent Australian legislation.
Estimate the per item selling price of new line of clothing : You have been asked to estimate the per item selling price of a new line of clothing. Use the estimated time complete item number 50 as your standard time for the purpose estimating the selling price per item( rounded to the nearest cent).
Composition of functions : Problem 1: Given that f (x) = 5x - 7 and g (x) = 5 - x2, calculate
What is your expected wealth with each investment : You have $1,000, which you can invest in a risk-free investment, earning 2% with certainty. Alternatively, you can invest in a project that has a 30% chance of losing $500, and a 70% chance of gaining $400. What is your expected wealth with each inve..

Reviews

Write a Review

Finance Basics Questions & Answers

  Charging different groups of customers different prices

Determine the purpose of charging different groups of customers different prices? Provide the three broad examples in the Last Word with two additional examples of your own.

  Converting trial balances from foreign currencies

What are the two methods used to convert trial balances from foreign currencies into U.S. dollars? Describe the situations when you would use each metod.

  Phases of the capital budgeting process

Explain why buying common stocks based on each of the following financial ratios would or would not be a good investment strategy:  (a) a low price/sales (P/S) ratio; (b) a high dividend yield; (c) a high risk premium, based on Treynor's measure.

  Discuss the process of capital budgeting

Five brief articles to reference are found on the "Headlines" page of the menu for GE on YahooFinance. These articles were posted on Thursday, April 21, 2011 and Friday, April 22, 2011. Discuss and explain the process of capital budgeting.

  Calculate the net present value-internal rate of return

Calculate the net present value, internal rate of return, and simple payback. Next, determine the effect that each of the three (3) values will have on the company.

  Efficient frontier

Create a reasonable, but hypothetical, graph that shows risk, as measured by portfolio standard deviation, on the X axis and expected rate of return on the Y axis.

  The capital markets and the ability to raise funds for corpo

The capital markets and the ability to raise funds for corporate uses are essential to the US economic systems.  For this assignment, imagine that you have $25,000 to invest in US companies. You are buying used stock. The company got the money when i..

  What is the firm days sales outstanding

What is the firm's days sales outstanding? Assume a 365-day year for this calculation.

  What is the standard deviation of unit sales

Lowe Tech Co. is evaluating the introduction of a new product. The possible levels of unit sales and the probabilities of their occurrence are given.

  The company expects investors to pay 910 for the 20-year

a company is going to issue a 1000 par value bond which pays 8 in annual interest. the company expects investors to

  Consulting income at kate walsh associates for the period

consulting income at kate walsh associates for the period february-july has been as followsmonth income 1000sfebruary

  What is the present value of the dividends to be received

Three years from now it expects to pay a dividend of $2.50 and then $3.00 in the following two years. What is the present value of the dividends to be received over the next five years if the discount rate is 15 percent.

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