(Excel) Assume that two investments...(See picture below, please solve in excel and show formulas used, Thank you :) )
Homework Answers
| A | B | ||
| a | Payback | 5.19 | 5.18 |
| b | NPV | $14,988.53 | $13,119.84 |
| c | IRR | 11.24% | 10.88% |
Workings
| Year | A | Cumulative CF | B | Cumulative CF |
| 0 | -90000 | -90000 | -90000 | -90000 |
| 1 | 14440 | -75560 | 16000 | -74000 |
| 2 | 15015 | -60545 | 16000 | -58000 |
| 3 | 15615 | -44930 | 16000 | -42000 |
| 4 | 16240 | -28690 | 16000 | -26000 |
| 5 | 16890 | -11800 | 16000 | -10000 |
| 6 | 62565 | 50765 | 57000 | 47000 |
Payback = Year in which Cumulative CF is last negative -(Last negative cumulative CF/ CF of next year
Add Answer to:
(Excel) Assume that two investments...(See picture below, please
solve in excel and show formulas used, Thank...
please show excel formulas so I can understand the problem thanks 9-59 Two equipment investments are...
please show excel formulas so I can understand the problem
thanks
9-59 Two equipment investments are estimated as follows: Year A 0 -$15,000 $18,000 5,000 6,500 5,000 6,500 5,000 6,500 5,000 6,500 5,000 6,500 Which investment has the better discounted payback period if i = 14%?
Can you please show the steps of how to solve (in excel preferred) please, thank you!...
Can you please show the steps of how to solve (in excel
preferred) please, thank you!
Long-term investment decision, payback method Personal Finance Problem Bill Williams has the opportunity to invest in project A that costs $10.000 today and promises to pay $2,400, $2,300, $2,300, $2.200 and $1,700 over the next 5 years. Or, Bill can invest $10,000 in project B that promises to pay $1,200, $1,200, $1,200, $3,800 and $4,200 over the next 5 years. (Hint: For mixed stream,...
please show excel formulas for both explicit and implicut methods please solve using excel and show...
please show excel formulas for both explicit and implicut
methods
please solve using excel and show formulas You are given the following system of differential equations: 99x, +2999x 2000x1 - 3000x2 If x1(0)=x2(0)-1, obtain a solution from t=0 to 0.3 using a step size of 0.03 with a. The explicit Euler's method b. The implicit Euler's method (note that this problem can be solved via a set of simultaneous linear equations for each time step) C. Plot all results on...
PLEASE solve and show formulas used in Excel! I am so slow at this! thank you!...
PLEASE solve and show formulas
used in Excel! I am so slow at this! thank you! :)
Use the cells on this sheet to make calculations. Calculate the probability of pulling 4 straight Kings or Queens one after the other from a deck of 52 cards. Calculate the probability of pulling 2 face cards (King or Queen or Jack) in 3 tries from a deck of 52 cards.
Revenue Quarterly (Please show clearly what formulas were used in excel) In excel using the correct...
Revenue Quarterly (Please show clearly what formulas were used in excel) In excel using the correct method/formula provide the correct values for each revenue item 2018 complete the formulas in cells provided for revenues for 2019. 2019 revenues have increased by 3/4 % over 2018 values Focused Revenue Investment (FRI) Quarterly Schedule of Revenue For the year December 31, 2018 QTR1 QTR2 QTR3 QTR4 2018 Sales 280,000 310,000 320,000 500,000 1,410,000 Interest 102,500 ...
Edit: Please do not use Excel as I need to learn to solve without it. thank...
Edit: Please do not use Excel as I need to learn to solve without
it. thank you.
Problem 4 After paying $3 million for a feasibility study, Stanley wrote a proposal with the following cash flow estimates for a 25-year capital project. Equipment cost: $34 million, Shipping costs: $1 million, Installation: S19 million, Salvage: $4, Working capital investment: $2 million, Revenues are expected to increase by $20 million per year and cash operating expenses by $9 million per year. The...
Please show all your work and identify formulas used. P12.1A (LO 1, 2,5), AN U3 Company...
Please show all your work and
identify formulas used.
P12.1A (LO 1, 2,5), AN U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Compute annual rate of return, cash payback, and net present value C Excel Project Bono $160,000 Project Edge $175,000 Project Clayton $200,000 Capital investment Annual net income: Year 1 نا نية 14,000 14,000 14,000 14,000 14,000 $ 70,000 18,000 17,000...
*Please show all excel formulas used* Thank you! 29. Project Analysis and Inflation Earp Brothers, Inc.,...
*Please show all excel formulas
used* Thank you!
29. Project Analysis and Inflation Earp Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $990,000 and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 13,000 keyboards each year. The price of each keyboard will be $87 in the first year and will increase by 5 percent per year. The...
Please show in excel format.... With formulas.. Thank you 5.44 Dark Skies Observatory is considering several...
Please show in excel format.... With formulas.. Thank you 5.44 Dark Skies Observatory is considering several options to purchase a new deep-space telescope. Revenue would be generated from the telescope by selling ‘‘time and use’’ slots to various researchers around the world. Four possible telescopes have been identified in addition to the possibility of not buying a telescope if none are financially attractive. The table below details the characteristics of each telescope. A present worth ranking analysis is to be...
please help me solve this problem with excel formulas please and thank you!! A financial planning...
please help me solve this problem with excel formulas please and
thank you!!
A financial planning service offers a unique program for parents to save for a child's college education. Starting on the child's 12th birthday, annual deposits are made. The first deposit is $5,000 and the required deposit increases by $1000 each year, until the child's 18th birthday, when the final deposit is made. Beginning on the child's 19th birthday, four annual withdrawals of $10,000 can be made. Assuming...
please show excel formulas so I can understand the problem
thanks
9-59 Two equipment investments are estimated as follows: Year A 0 -$15,000 $18,000 5,000 6,500 5,000 6,500 5,000 6,500 5,000 6,500 5,000 6,500 Which investment has the better discounted payback period if i = 14%?
Can you please show the steps of how to solve (in excel
preferred) please, thank you!
Long-term investment decision, payback method Personal Finance Problem Bill Williams has the opportunity to invest in project A that costs $10.000 today and promises to pay $2,400, $2,300, $2,300, $2.200 and $1,700 over the next 5 years. Or, Bill can invest $10,000 in project B that promises to pay $1,200, $1,200, $1,200, $3,800 and $4,200 over the next 5 years. (Hint: For mixed stream,...
please show excel formulas for both explicit and implicut
methods
please solve using excel and show formulas You are given the following system of differential equations: 99x, +2999x 2000x1 - 3000x2 If x1(0)=x2(0)-1, obtain a solution from t=0 to 0.3 using a step size of 0.03 with a. The explicit Euler's method b. The implicit Euler's method (note that this problem can be solved via a set of simultaneous linear equations for each time step) C. Plot all results on...
PLEASE solve and show formulas
used in Excel! I am so slow at this! thank you! :)
Use the cells on this sheet to make calculations. Calculate the probability of pulling 4 straight Kings or Queens one after the other from a deck of 52 cards. Calculate the probability of pulling 2 face cards (King or Queen or Jack) in 3 tries from a deck of 52 cards.
Edit: Please do not use Excel as I need to learn to solve without
it. thank you.
Problem 4 After paying $3 million for a feasibility study, Stanley wrote a proposal with the following cash flow estimates for a 25-year capital project. Equipment cost: $34 million, Shipping costs: $1 million, Installation: S19 million, Salvage: $4, Working capital investment: $2 million, Revenues are expected to increase by $20 million per year and cash operating expenses by $9 million per year. The...
Please show all your work and
identify formulas used.
P12.1A (LO 1, 2,5), AN U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Compute annual rate of return, cash payback, and net present value C Excel Project Bono $160,000 Project Edge $175,000 Project Clayton $200,000 Capital investment Annual net income: Year 1 نا نية 14,000 14,000 14,000 14,000 14,000 $ 70,000 18,000 17,000...
*Please show all excel formulas
used* Thank you!
29. Project Analysis and Inflation Earp Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $990,000 and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 13,000 keyboards each year. The price of each keyboard will be $87 in the first year and will increase by 5 percent per year. The...
please help me solve this problem with excel formulas please and
thank you!!
A financial planning service offers a unique program for parents to save for a child's college education. Starting on the child's 12th birthday, annual deposits are made. The first deposit is $5,000 and the required deposit increases by $1000 each year, until the child's 18th birthday, when the final deposit is made. Beginning on the child's 19th birthday, four annual withdrawals of $10,000 can be made. Assuming...
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