Estimate the new present value and uniform annual cash flow

Assignment Help Econometrics
Reference no: EM13189857

Brainger, Inc., is purchasing new production equipment to support its facility expansion. The equipment will cost $175,000 in year zero, and it will generate $122,500 sales revenue in its first year of operation, $132,000 in its second year, and $140,000 in years three through seven. Due to product phase-out, sales revenue will be $135,500 in year 8, $127,500 in year 9, and $125,000 in year 10. Annual operating expenses for the equipment will be $90,000 in its first and second years, and $95,000 in years 3 through 5, $97,500 in year 6, $100,000 in year 7, $105,000 in year 8, and $112,500 in year 9, and $117,500 in year 10. Brainger uses a 14% interest rate for its projects. Set up an Excel spreadsheet and show how the cash flows for this new equipment and estimate the new present value and uniform annual cash flow generated by the equipment using the appropriate Excel financial functions.

Reference no: EM13189857

Questions Cloud

Determine necessary full-employment real output : Use the data above to graph the aggregate demand and aggregate supply curves. What is the equilibrium price level and the equilibrium level of real output in this hypothetical economy Is the equilibrium real output also necessarily the full-employ..
What is the definition of an oncogene : What is the definition of an Oncogene? What are cyclins? In terms of Structure or Function, are the products of Oncogenes and cylins the same or very different entities in our cells?
What fiscal policies and monetary policies be appropriate : What is the "current macroeconomic situation" in the U.S. (e.g. is the U.S. economy currently concerned about unemployment, inflation, recession, etc.)? What fiscal policies and monetary policies would be appropriate at this time
Atlantic slave trade and the institution of slavery : discuss slavery in historical perspective, Portuguese and the Spanish filling their colonies with African slaves, very brutal form of slavery, particularly sugar islands, sugar transforms the slave trade, Madeira, competition in the slave trade, the ..
Estimate the new present value and uniform annual cash flow : Brainger, Inc., is purchasing new production equipment to support its facility expansion. The equipment will cost $175,000 in year zero, and it will generate $122,500 sales revenue in its first year of operation, $132,000 in its second year, and $..
How is food choice an adaptive behavior : How is food choice an adaptive behavior? Find two current peer-reviewed journal articles that support your position. Briefly review their strengths and weaknesses in support of your position.
Calculate income-elasticity of demand coefficient of product : Use the arc-approximation formula to calculate the price-elasticity of demand coefficient of a firm's product demand between the (quantity, price) points of (100, $20) and (300, $10). (b) Calculate the cross-price elasticity of demand coefficient ..
Using the library-online databases or internet-research meta : Using the library, online databases, or Internet, research meta, normative, and applied ethics, find one website and one related article on each of the following:
Useful for enabling the owl to detect : The barn owl's right ear opens slightly upward while its left ear opens slightly downward. This asymmetry is most useful for enabling the owl to detect the ________ of a sound.

Reviews

Write a Review

Econometrics Questions & Answers

  Cost effectiveness of a preventive maintenance event

Dr. Izobel Stevens is physician at the Westbury HMO, a New York City based medical facility serving the poor and indigent. Stevens is estimating the cost effectiveness of a preventive maintenance event,

  What would be your profit per bushel of rice

Explain how you could make a profit from this situation. What would be your profit per bushel of rice If other people exploit the same opportunity, what would happen to the price of rice in Japan and the price of rice of rice in the United States..

  Determine the effective monthly interest rate

Picabo borrows $1000. To repay the amount, she makes 12 equal monthly payments of $90.30. Determine the effective monthly interest rate, the nominal annual interest rate, and the effective annual interest rate

  Calculate points on the aggregate demand curve

Given that monetary policymakers, firms, and workers all recognize that the decline in the real exchange rate is only temporary and given the three policy responses described in part d of 580 Chapter 17 New Classical Macro Confronts New Keynesian ..

  Calculate the supply and demand elasticities

Consider that the U.S. supply of ethanol follows the function S(p) = 5p, and that the US demand for ethanol is D(p) = 13.5 - 2.5p. Without any government role, there are in equilibrium 9 Billion gallons/year transacted at a price of $1.80/gallon.

  Determine the mrs

I have two goods, Xb and Xw, for beer and wine, and I need to draw the indifference map and determine the MRS. U(Xb, Xw) = min { Xb; aXw}, a>0. What do I need to do here? What does this look like?

  Find the steady-state equilibrium level of gdp per capita

Analyze basic growth data for Austria for the period 1970 to 2007. Find the Steady-state equilibrium level of GDP per capita and real GDP growth rate. Variables Gross Output (real GDP) Net Output (real NDP) Depreciation InvestmentICT Investment

  Discuss how to write the demand curve

In Bayonne, NJ there is a large beauty salon and a number of smaller ones.The total demand function for hair styling per day is Q=180 - 10P, where P is in dollars The marginal cost function of all the small salons together is SMCf = 4+ 0.1Q

  Measure the marginal utility per dollar

Let MUA = z = 10 ? x and MUB = z = 21 2y, where z is marginal utility per dollar measured in utils, x is the amount spent on product A, and y is the amount spent on product B. Assume that the consumer has $10 to spend on A and B-that is, x + y = 1..

  Determine the point at which diminishing returns occur

The Oceanic Pacific fleet has just decided to use a pole-and-line method of fishing instead of gill netting to catch tuna. The latter method involves the use of miles of net strung out across the ocean and therefore entraps other sea creatures be..

  Determine extreme points of linear combination

Suppose that two people, Michelle and James each live alone in an isolated region. They each have the same resources available, and they grow potatoes and raise chickens. If Michelle devotes all her resources to growing potatoes, she can raise 200..

  Determine which product mix should be pushed

Assume that product A requireds .5 hour per unit and B requires .25 hour per unit. If both products must go through the same manufacturing machine and there are only 30000 machine hours available per period, which product should be pushed

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