(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,...
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 ...
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...
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...
What is the depreciation for the following years, please include the excel formulas. Thank You The...
What is the depreciation for the following years, please
include the excel formulas. Thank You
The office space Janelle plans to rent is unfurnished. She plans to purchase $15,000 worth of furniture and fixtures at the beginning of Year 1. The furniture and fixtures will have a useful life of 15 years. Janelle will also need to buy some computers and other office equipment that she will purchase for $10,000 also at the beginning of Year 1. The office equipment...
The answer is shown in the picture, i want to know how they got it, please show all your work and if you are using excel please show your formulas, Thank You and good luck. Toll lanes on a section of...
The answer is shown in the
picture, i want to know how they got it, please show all your work
and if you are using excel please show your formulas, Thank You and
good luck.
Toll lanes on a section of the 1-40 freeway are being considered in order to reduce traffic congestion and travel times Since this is a government project, the B-C ratio method must be applied in the evaluation. Construction costs of the project are estimated to...
if excel is used, show all formulas please :) Two ambitious business graduates, Boris and Isabelle,...
if excel is used, show all formulas please :)
Two ambitious business graduates, Boris and Isabelle, are considering purchasing Premier Pizza, a frozen pizza manufacturer. Forecasted annual sales for the coming year are $10.3 million, with operating costs equal to 85% of sales, depreciation is 6% of sales and required annual investment in equipment is 4% of sales. Sales, costs, and investments are expected to grow 4% in perpetuity. On the basis of their analysis of the industry, Boris and...
SHOW ANSWERS WITH FORMULAS ON EXCEL PLEASE & Formatting Table Styles Styles Clipboard Font 028 4...
SHOW ANSWERS WITH FORMULAS ON EXCEL PLEASE
& Formatting Table Styles Styles Clipboard Font 028 4 D E 2.750.000 1.600.000 1.150.000 $ А B 1 Laurman, Inc. is considering the following project: 2 Required investment in equipment $ 2.205.000 3 Project life 7 4 Salvage value 225.000 5 The project would provide net operating income each year as follows: 7 Sales 8 Variable expenses 9 Contribution margin 10 Fixed expenses: 11 Salaries, rent and other fixed out of pocket costs...
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 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...
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...
What is the depreciation for the following years, please
include the excel formulas. Thank You
The office space Janelle plans to rent is unfurnished. She plans to purchase $15,000 worth of furniture and fixtures at the beginning of Year 1. The furniture and fixtures will have a useful life of 15 years. Janelle will also need to buy some computers and other office equipment that she will purchase for $10,000 also at the beginning of Year 1. The office equipment...
The answer is shown in the
picture, i want to know how they got it, please show all your work
and if you are using excel please show your formulas, Thank You and
good luck.
Toll lanes on a section of the 1-40 freeway are being considered in order to reduce traffic congestion and travel times Since this is a government project, the B-C ratio method must be applied in the evaluation. Construction costs of the project are estimated to...
if excel is used, show all formulas please :)
Two ambitious business graduates, Boris and Isabelle, are considering purchasing Premier Pizza, a frozen pizza manufacturer. Forecasted annual sales for the coming year are $10.3 million, with operating costs equal to 85% of sales, depreciation is 6% of sales and required annual investment in equipment is 4% of sales. Sales, costs, and investments are expected to grow 4% in perpetuity. On the basis of their analysis of the industry, Boris and...
SHOW ANSWERS WITH FORMULAS ON EXCEL PLEASE
& Formatting Table Styles Styles Clipboard Font 028 4 D E 2.750.000 1.600.000 1.150.000 $ А B 1 Laurman, Inc. is considering the following project: 2 Required investment in equipment $ 2.205.000 3 Project life 7 4 Salvage value 225.000 5 The project would provide net operating income each year as follows: 7 Sales 8 Variable expenses 9 Contribution margin 10 Fixed expenses: 11 Salaries, rent and other fixed out of pocket costs...
Most questions answered within 3 hours.
-
Write a program to solve the Josephus problem, with the following
modification:
Sample Input:
./a.out n...
asked 1 hour ago -
At the start of a CD it is spinning at a rate of 525 rpm
(revolutions...
asked 2 hours ago -
4. Without doing any calculations, predict whether the observed
∆T would increase, decrease or remain the...
asked 3 hours ago -
Based on the range, which of the following sets of scores has
the greatest variability? 3,...
asked 4 hours ago -
Ripples in a pond travel at a velocity of 3 m/s with one peak
passing a...
asked 4 hours ago -
A man stands on the roof of a building of height 13.0 mm and
throws a...
asked 4 hours ago -
The extent to which assets are financed by borrowed funds and
other liabilities is indicated by:...
asked 5 hours ago -
Explain in detail
Germany is the fifth largest economy
explain what goods and services Germany specializes...
asked 6 hours ago -
The density of platinum is 21.45 g/mL. If a cube of platinum
with a mass of...
asked 6 hours ago -
Accounts Receivable
Sales
A/R Posting
Extended Sales Invoice
Packing Slip
Compare invoice to packing slip 2...
asked 6 hours ago -
Michaella, age 23, is a full-time law student and is claimed by
her parents as a...
asked 6 hours ago -
Why are polymers not typically casted into products?
asked 6 hours ago