Hi, Please help!! I'm looking for an EXCEL SHEET answer shown with excel formulas. PLease show all of your work. Thank you so much.
Homework Answers
Net Present Value = Present value of cash benefits - Present Value of Cash outflow
Calculation of Net Present Value
| Year | 1 | 2 | 3 | 4 | 5 |
| Old Operating cost | 850000 | 935000 | 1028500 | 1131350 | 1244485 |
| New Operating cost | 250000 | 250000 | 250000 | 250000 | 250000 |
| Cost Benefit | 600000 | 685000 | 778500 | 881350 | 994485 |
| Discounting Factor @ 12% | 0.892857 | 0.797194 | 0.71178 | 0.635518 | 0.567427 |
| Present Value of Benefit | 535714.3 | 546077.8 | 554120.9 | 560113.9 | 564297.5 |
| Total Present Value | 2760324 | ||||
| Less: Total Cost of new system | 1336000 | ||||
| Net Present Value | 1424324 |
Net Present Value = Present value of cash benefits - Present Value of Cash outflow.
Answer: The Company should engage in New CRM product development because the NPV is positive.
Note: Excel Formulas
Add Answer to:
Hi, Please help!! I'm looking for an EXCEL SHEET answer shown
with excel formulas. PLease show...
Help solve ONLY (b) with excel. Please show step by step 2-40. Fox Enterprises is considering...
Help solve ONLY (b) with excel. Please show step by
step
2-40. Fox Enterprises is considering six projects for possible construction over the next four years. Fox can undertake any of the projects partially or completely. A partial undertaking of a project will prorate both the return and cash outlays proportionately. The expected (present value) returns and cash outlays for the projects are given in the following table. Cash outlay ($1000) Year 2 Year 3 Project Year 1 Year 4...
Q. 1: Excel (attach your solution to this sheet A medium-size municipality plans to develop a...
Q. 1: Excel (attach your solution to this sheet A medium-size municipality plans to develop a software system to assist in project selection during the next 10 years. A life-cycle cost approach has been used to categorize costs into development programming, operating, and support costs for each alternative. There are three alternatives under consideration, identified as M, N, and O. The costs are summarized on in the table. Use an annual life-cycle cost approach to identify the best alternative at...
Excel sheet, please. Calculating NPV Thurston Petroleum is considering a new project that complements its existing...
Excel
sheet, please.
Calculating NPV Thurston Petroleum is considering a new project that complements its existing business. The machine required for the project costs $4.1 million. The mar- keting department predicts that sales related to the project will be $2.35 million per year for the next four years, after which the market will cease to exist. The machine will be depreciated to zero over its 4-year economic life using the straight-line method. Cost of goods sold and operating expenses related...
Please do it in excel format You have been asked by the CEO of the company...
Please do it in excel format
You have been asked by the CEO of the company to lead a project evaluation team of company specialists and consultants to develop estimates of the likely revenues and costs associated with building and operating a new production and fabricating plant in Brisbane for ten years, and to provide a recommendation on the project. The CEO plans to take your recommendation to the November 2019 meeting of the company's Board of Directors. You have...
PLEASE ANSWER USING EXCEL and put in cells viewing mode Bid Problem: Your firm has been...
PLEASE ANSWER USING EXCEL and put in cells viewing mode
Bid Problem: Your firm has been asked to submit a bid for a new computerized cash register system. The system would be installed in 50 stores per year for the next 4 years. Your firm would need to purchase $800,000 worth of specialized equipment. The CCA rate would be 30%. Your firm will be able to sell the machine for $150,000 in 4 years time. Your firm has estimated that...
Please answer using excel ONLY & add formulas 123 Inc. is considering purchasing a new machine....
Please answer using excel ONLY & add formulas
123 Inc. is considering purchasing a new machine. The machine will cost $3,500,000. The machine will be used for a project that lasts 3 years. The expected salvage of the machine at the end of the project is $300,000. The machine will be used to produce widgets. The marketing department has forecasted that the company will be able to sell 280,000 widgets per year. The marketing department believes that the company will...
please use excel to answer the questions and show all outputs E3) The Erley Equipment Company...
please use excel to answer the questions and show all
outputs
E3) The Erley Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and an expected salvage value of $10,000 at the end of the 10 years. It is being depreciated by the straight line method toward a salvage value of $10,000, or by $9,000 per year. A new machine can be...
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...
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...
Please show ALL EXCEL FORMULAS! BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company...
Please show ALL EXCEL FORMULAS!
BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Bethesda, has been hard-hit by environmental regulations. Recently, however, a combination of increased demand for coal...
Help solve ONLY (b) with excel. Please show step by
step
2-40. Fox Enterprises is considering six projects for possible construction over the next four years. Fox can undertake any of the projects partially or completely. A partial undertaking of a project will prorate both the return and cash outlays proportionately. The expected (present value) returns and cash outlays for the projects are given in the following table. Cash outlay ($1000) Year 2 Year 3 Project Year 1 Year 4...
Q. 1: Excel (attach your solution to this sheet A medium-size municipality plans to develop a software system to assist in project selection during the next 10 years. A life-cycle cost approach has been used to categorize costs into development programming, operating, and support costs for each alternative. There are three alternatives under consideration, identified as M, N, and O. The costs are summarized on in the table. Use an annual life-cycle cost approach to identify the best alternative at...
Excel
sheet, please.
Calculating NPV Thurston Petroleum is considering a new project that complements its existing business. The machine required for the project costs $4.1 million. The mar- keting department predicts that sales related to the project will be $2.35 million per year for the next four years, after which the market will cease to exist. The machine will be depreciated to zero over its 4-year economic life using the straight-line method. Cost of goods sold and operating expenses related...
Please do it in excel format
You have been asked by the CEO of the company to lead a project evaluation team of company specialists and consultants to develop estimates of the likely revenues and costs associated with building and operating a new production and fabricating plant in Brisbane for ten years, and to provide a recommendation on the project. The CEO plans to take your recommendation to the November 2019 meeting of the company's Board of Directors. You have...
PLEASE ANSWER USING EXCEL and put in cells viewing mode
Bid Problem: Your firm has been asked to submit a bid for a new computerized cash register system. The system would be installed in 50 stores per year for the next 4 years. Your firm would need to purchase $800,000 worth of specialized equipment. The CCA rate would be 30%. Your firm will be able to sell the machine for $150,000 in 4 years time. Your firm has estimated that...
Please answer using excel ONLY & add formulas
123 Inc. is considering purchasing a new machine. The machine will cost $3,500,000. The machine will be used for a project that lasts 3 years. The expected salvage of the machine at the end of the project is $300,000. The machine will be used to produce widgets. The marketing department has forecasted that the company will be able to sell 280,000 widgets per year. The marketing department believes that the company will...
please use excel to answer the questions and show all
outputs
E3) The Erley Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and an expected salvage value of $10,000 at the end of the 10 years. It is being depreciated by the straight line method toward a salvage value of $10,000, or by $9,000 per year. A new machine can be...
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...
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...
Please show ALL EXCEL FORMULAS!
BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Bethesda, has been hard-hit by environmental regulations. Recently, however, a combination of increased demand for coal...
Most questions answered within 3 hours.
-
The Williams have a stock they have held for over a year that
they believe is...
asked 43 minutes ago -
11.53g sample of NaBr contains 22.34% Na by mass Considering
the law of constant composition how...
asked 1 hour ago -
Exercise 5-22A Complete the accounting cycle using receivable
transactions (LO5–1, 5–2, 5–4, 5–5, 5–7) [The following...
asked 2 hours ago -
Do you agree with the view that small businesses are more
vulnerable to employee theft because...
asked 2 hours ago -
Four forces act on an object, given by A = 41.3 N east, B = 46.3...
asked 3 hours ago -
Which of the following design considerations leads to more
user-friendly presentation layers for GUIs? [Check all...
asked 4 hours ago -
38%
of adults say cashews are their favorite kind of nut. You
randomly select 12 adults...
asked 6 hours ago -
Notational Inc. is considering installing a new server. The
machine costs $100,000 and is expected to...
asked 6 hours ago -
Given the information coding of DNA strand:
5'-TTT-TAC-GAA-GAG-TGA-3',
Write the corresponding DNA template and mRNA strand...
asked 6 hours ago -
2. Boris recently synthesized an explosive compound he named
Badenoughium. The molecular formula for Bdenoughium is...
asked 10 hours ago -
5. A car decelerate evenly from a velocity of 50mph until rest
in a distance of...
asked 10 hours ago -
IN HTML Programming
1. Write a script that inputs integers (one at a time) and
passes...
asked 10 hours ago