please show excel formulas so I can understand the problem
thanks
Homework Answers
Using NPER function in Excel
| year | Cash Flow A | Cash Flow B |
| 0 | -15000 | -18000 |
| 1 | 5000 | 6500 |
| 2 | 5000 | 6500 |
| 3 | 5000 | 6500 |
| 4 | 5000 | 6500 |
| 5 | 5000 | 6500 |
| 6 | 5000 | 6500 |
| Payback | 4.16 | 3.74 |
As Payback is less in case of B, it should be selected
Showing formula in excel
| year | Cash Flow A | Cash Flow B |
| 0 | -15000 | -18000 |
| 1 | 5000 | 6500 |
| 2 | 5000 | 6500 |
| 3 | 5000 | 6500 |
| 4 | 5000 | 6500 |
| 5 | 5000 | 6500 |
| 6 | 5000 | 6500 |
| Payback | =NPER(14%,B148,B142) | =NPER(14%,C148,C142) |
Add Answer to:
please show excel formulas so I can understand the problem
thanks
9-59 Two equipment investments are...
9-59 Two equipment investments are estimated as follows: Year -$15,000 5,000 5,000 5,000 5,000 5,000 -$18,000...
9-59 Two equipment investments are estimated as follows: Year -$15,000 5,000 5,000 5,000 5,000 5,000 -$18,000 6,500 6,500 6,500 in 6,500 6,500 Which investment has the better discounted payback period if i = 14%?
9-59 Two equipment investments are estimated as follows: Year 1 -$15,000 5,000 5,000 5,000 5,000 5,000...
9-59 Two equipment investments are estimated as follows: Year 1 -$15,000 5,000 5,000 5,000 5,000 5,000 -$18,000 6,500 6,500 6,500 6,500 6,500 Which investment has the better discounted payback period if i = 14%?
9-59 Two equipment investments are estimated as follows: Year A в -$15,000$18,000 0 5,000 1 6,500...
9-59 Two equipment investments are estimated as follows: Year A в -$15,000$18,000 0 5,000 1 6,500 5,000 2 6,500 5,000 6,500 4 5,000 6,500 5 6,500 5,000 Which investment has the better discounted payback period if i 14%?
9-59 Two equipment investments are estimated as follows: Year A B 0 -15,000 -18,000 1 5,000...
9-59 Two equipment investments are estimated as follows: Year A B 0 -15,000 -18,000 1 5,000 6,500 2 5,000 6,500 3 5,000 6,500 4 5,000 6,500 5 5,000 6,500 Which investment has the better discounted payback period if interest = 14%
please show excel formulas so I can understand the problem THANKS 9-50 Consider four mutually exclusive...
please show excel formulas so I can understand the problem
THANKS
9-50 Consider four mutually exclusive alternatives: (Α) A B C D Cost $75.0 $50.0 $15.0 $90.0 Uniform annual 18.8 13.9 4.5 23.8 benefit Each alternative has a 5-year useful life and no sal- vage value. The MARR is 10%. Which alternative should be selected, based on (a) The payback period (b) Future worth analysis (c) Benefit-cost ratio analysis
8-14 A The following four mutually exclusive alternatives have no salvage value after 10 years. A...
8-14 A The following four mutually exclusive alternatives have no salvage value after 10 years. A B C D First cost $7500 $5000 $5000 $8500 Uniform annual benefit 1600 1200 1000 1700 Computed rate of return 16.8% 20.2% 15.1% 15.1% (a) Construct a choice table for interest rates from 0% to 100%. (b) Using 8% for the MARR, which alternative should be selected? 9-59 Two equipment investments are estimated as follows: Year 0 - $15,000 5,000 5,000 5,000 5,000 5,000...
(Excel) Assume that two investments...(See picture below, please solve in excel and show formulas used, Thank...
(Excel) Assume that two investments...(See picture below, please
solve in excel and show formulas used, Thank you :) )
3. (Excel) Assume that two investments each cost $90000 initially. The returns are as follows: Investment End of year Type B. COST -90000 -90000 INCOME 14440 16000 INCOME 15015 16000 INCOME 15615 16000 INCOME 16240 16000 INCOME 16890 16000 INCOME 17565 16000 SALVAGE 45000 41000 a. Which investment is preferred using the payback method? b. Which investment is preferred using the...
*******Please show ALL WORK/FORMULAS IN EXCEL AND SEPARATE THE ANSWERS FOR A/B/C SO I CAN CLEARLY...
*******Please show ALL WORK/FORMULAS IN EXCEL AND SEPARATE THE ANSWERS FOR A/B/C SO I CAN CLEARLY SEE THEM****** TAKE PICTURES OF FORMULAS IN EXCEL AND PASTE THEM HERE. SHOW WHERE EACH CORRESPONDING FORMULA BELONGS IN EACH CELL, ETC 1. Moving Average Model (please review spreadsheet model of Forecast 1.xlsx.) Given the annual sales (in $1000s) for a small business (See 1st worksheet in Assignment 2.xlsx), answer the following questions. Please use 2-period Moving Average method to forecast the sales in...
PLEASE HELP ME UNDERSTAND THIS PROBLEM IN EXCEL WITH ALL THE EXCEL FORMULAS. Annual cash inflows...
PLEASE HELP ME UNDERSTAND THIS PROBLEM IN EXCEL WITH ALL THE EXCEL FORMULAS. Annual cash inflows that will arise from two competing investment projects are given below: Year Investment A Investment B 1 $ 5,000 $8,000 2 6,000 7,000 3 7,000 6,000 4 8,000 5,000 Total $26,000 $26,000 The discount rate is 9%. Required: Compute the present value of the cash inflows for each investment. Each investment opportunity will require the same initial investment. (Use Microsoft Excel...
Please use formulas and hand-work, it helps me better understand as I cannot use excel Problem...
Please use formulas and hand-work, it helps me better understand
as I cannot use excel
Problem 2 What are the present value and future value of S900 to be received at the END of each year for the next 5 years if the discount/compounding is 7%?
9-59 Two equipment investments are estimated as follows: Year -$15,000 5,000 5,000 5,000 5,000 5,000 -$18,000 6,500 6,500 6,500 in 6,500 6,500 Which investment has the better discounted payback period if i = 14%?
9-59 Two equipment investments are estimated as follows: Year 1 -$15,000 5,000 5,000 5,000 5,000 5,000 -$18,000 6,500 6,500 6,500 6,500 6,500 Which investment has the better discounted payback period if i = 14%?
9-59 Two equipment investments are estimated as follows: Year A в -$15,000$18,000 0 5,000 1 6,500 5,000 2 6,500 5,000 6,500 4 5,000 6,500 5 6,500 5,000 Which investment has the better discounted payback period if i 14%?
please show excel formulas so I can understand the problem
THANKS
9-50 Consider four mutually exclusive alternatives: (Α) A B C D Cost $75.0 $50.0 $15.0 $90.0 Uniform annual 18.8 13.9 4.5 23.8 benefit Each alternative has a 5-year useful life and no sal- vage value. The MARR is 10%. Which alternative should be selected, based on (a) The payback period (b) Future worth analysis (c) Benefit-cost ratio analysis
8-14 A The following four mutually exclusive alternatives have no salvage value after 10 years. A B C D First cost $7500 $5000 $5000 $8500 Uniform annual benefit 1600 1200 1000 1700 Computed rate of return 16.8% 20.2% 15.1% 15.1% (a) Construct a choice table for interest rates from 0% to 100%. (b) Using 8% for the MARR, which alternative should be selected? 9-59 Two equipment investments are estimated as follows: Year 0 - $15,000 5,000 5,000 5,000 5,000 5,000...
(Excel) Assume that two investments...(See picture below, please
solve in excel and show formulas used, Thank you :) )
3. (Excel) Assume that two investments each cost $90000 initially. The returns are as follows: Investment End of year Type B. COST -90000 -90000 INCOME 14440 16000 INCOME 15015 16000 INCOME 15615 16000 INCOME 16240 16000 INCOME 16890 16000 INCOME 17565 16000 SALVAGE 45000 41000 a. Which investment is preferred using the payback method? b. Which investment is preferred using the...
Please use formulas and hand-work, it helps me better understand
as I cannot use excel
Problem 2 What are the present value and future value of S900 to be received at the END of each year for the next 5 years if the discount/compounding is 7%?
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago