Use MS Excel and turn in your XLS document. This work is to be turned in...

Use MS Excel and turn in your XLS document. This work is to be turned in individually.

Compute the present value of a project that has a lifetime of 7 years. The total investment is 1.5 million dollars. The depreciation method is MACRS-GDS classified as 5 year property. The tax rate is 21%. 43% of the investment is financed with a loan at 7% per year, payable in 5 yearly payments. The positive cash flows in each one of the seven years are $420,000 each year. The salvage value of the investment is $225,000 at the end of the 7th year. The MARR is 14%

Show all your computations in a single table in MS Excel.

please submit the excel screenshot of the results and the screenshot of the formula used in excel to do the calculation

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Answer the following questions and use Excel or this document to show your work. 1. Consider...

Answer the following questions and use Excel or this document to show your work. 1. Consider the following results for two samples randomly taken from two normal populations with equal variances. Sample I Sample II Sample Size 28 35 Sample Mean 48 44 Population Standard Deviation 9 10 a. Develop a 95% confidence interval for the difference between the two population means. b. Is there conclusive evidence that one population has a larger mean? Explain.

Kindly, do not hand write, use excel or word document, please let the work be original...

Kindly, do not hand write, use excel or word document, please let the work be original Capacity Planning Homework Assignment—To be Submitted The Baltimore Manufacturing Company’s management forecasts demand for each quarter as follows: First Quarter Second Quarter Third Quarter Fourth Quarter Average quarterly demand 7000 units 9000 units 10000 units 8000 units Assume that Arundel, Inc. started the First Quarter with 20 workers and 2000 units in inventory. The company wishes to finish the year with an inventory of...

(Use Excel) For many the promise of a college degree has turned to disappointment as they...

(Use Excel) For many the promise of a college degree has turned to disappointment as they find themselves struggling to find a job (Financial Times, June 1, 2012). It is especially disturbing since recent evidence suggests that graduating at bad economic times can impact the person’s earning power for a long time. An associate dean at a prestigious college wants to determine if the starting salary of his college graduates has declined from 2008 to 2010. He expects the variance...

Formulate the problem as a linear programming model use excel and show your excel work. Thank...

Formulate the problem as a linear programming model use excel and show your excel work. Thank you. To (cost, in 100's) From New york Philadelphia Chicago Boston Supply Tampa $9 $14 $12 $17 200 Miami 11 10 6 10 200 Fresno 12 8 15 7 200 Demand 130 170 100 50

Your clients, both just turned 40, will retire when they turn 62. They have a current...

Your clients, both just turned 40, will retire when they turn 62. They have a current salary at an annual rate of ($10,000*salary scalar + $100,000), being paid equally at the end of each month. They expect a 3% raise in their salary every year until they retire. They deposit 12% of their monthly salary in their 401(k) account that generates an annual rate of return of 10%, compounded daily. In addition, their employer matches their contribution with 5% of...

Please use excel and show all work and formulas. (I will give your work a like...

Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...

Locate an example of poor document design. Maybe there is a document you use at work...

Locate an example of poor document design. Maybe there is a document you use at work that is confusing, or perhaps a form you have had to fill out that was visually cluttered or otherwise hard to read (you might want to begin your search at a government website...). Provide a link to the document, attach the document, or post an image of the document in your post so that your classmates can view the document design. In your post,...

What is the differences of MS Word, MS Excel, MS Powerpoint?

Use Excel to show your work and include the formula in the cell to show how...

Use Excel to show your work and include the formula in the cell to show how you arrived at your figures. Round percentages (example if 49.2, round to 49). Background: ABC, Inc., produces widgets. The company manufactures three levels of widgets-Economy, Better and Best. Selected information on the widgets is given below. Economy Better Best Selling price per widget $40.00 $60.00 $90.00 Variable expense per widget production $22.00 $27.00 $31.50 Selling (5% of selling price) $2.00 $3.00 $4.50 All sales...

Note: You need to show your work. If you choose to use Excel for your calculations,...

Note: You need to show your work. If you choose to use Excel for your calculations, be sure to upload your well-documented Excel and to make note in this file how you arrived at your answers. If you choose to do the work by hand, Microsoft Word has an equation editor. Go to “Insert” and “Equation” on newer versions of Word. On older versions, go to “Insert” and “Object” and “Microsoft Equation.” Chapter 8 Reflection: The National Center for Education...

Subjects