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

  Design a simple econometric research project

Design a simple econometric research project

  Multiplicative decomposition method

Multiplicative decomposition method

  Market for cigarettes

The Australian government administers two programs that affect the market for cigarettes.

  Solve the forecast model

Solve the forecast model

  What are the marginal abatement cost functions

What are the marginal abatement cost functions for each of the two areas? Calculate the loss in the two areas due to over-control (for the rural area) and under-control (for the urban area).

  Write the t statistic for testing the null hypothesis

Explain why this model violates the assumption of no perfect collinearity.  Write the t statistic for testing the null hypothesis

  What is economics system

What is economics system? What are the types of economics system? Briefly explain each type of economics system by giving examples of nations that are close to each type

  Multiple choice questions related to market concentration

Determine when a competitively produced product generates negative externalities in production, the industry will,

  Calculating number of units produced by firm

Assume a company has the following production function: Q = 100 K.5 L1 . Currently, the company hires 1,000 workers and employs 100 units of capital.

  Question about mobile commerce

M-commerce also known as mobile commerce is being lumped in with several strategic internet plans. Explain some of the industries that are likely to use mobile commerce and how it is working for them.

  Calculating the average days past due and average flow time

Auto Data manufactures custom engineering testing machine. The following 5-orders are currently in the design department:

  Mechanism of an english auction and second price auction

Briefly discuss the difference between mechanism of an oral or English auction and a Vickrey or second price auction.

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