Set the entire question up in an Excel spreadsheet and answer all the questions clearly marked...

Set the entire question up in an Excel spreadsheet and answer all the questions clearly marked in your spreadsheet.

You are considering purchasing a machine (use your imagination) that will initially cost $205,000.00. The machine is expected to last 7 years, and you project that you can sell the worn out machine at the end of 7 years for $55,000.00

Annual operating cash inflows and outflows are projected as follows, and are assumed to occur at the end of each year: Both of years 1 and 2, cash inflow $66,000.00, cash outflow expenses $24,000.00; both of years 3 and 4, cash inflow $72,000.00, cash outflow expenses $27,000.00. In year 5 you have to shut down and rebuild the machine so cash inflows are only $35,000.00 and cash outflows are $44,000.00. In year 6 cash inflow is $65,000.00, and cash outflow expenses are $39,000.00. Finally, in year 7 cash operating inflow is $66,000.00 and cash operating expenses are $34,000.00.

What is the calculated payback period for this proposed investment?

1.b. If the required payback period for your firm is 6 years, would you purchase this machine? Why or why not?

Expert Solution

1. Payback period = 6.16 Years

2. sine payback period is more than 6 years it is not recommended to invest in the project

jeff jeffy answered 2 years ago

(Set the entire homework up in an Excel spreadsheet and answer all the questions clearly marked...

(Set the entire homework up in an Excel spreadsheet and answer all the questions clearly marked in your spreadsheet.) You are considering purchasing a machine (use your imagination) that will initially cost $205,000.00. The machine is expected to last 7 years, and you project that you can sell the worn out machine at the end of 7 years for $55,000.00 Annual operating cash inflows and outflows are projected as follows, and are assumed to occur at the end of each...

This assignment asks you to set up an Excel budget spreadsheet file that automatically prepares the...

This assignment asks you to set up an Excel budget spreadsheet file that automatically prepares the master budget for a company, given sales projections and information on beginning balances, production requirements, desired ending inventories, etc. Information on developing the budgets appears in Chapter 8 of your text, and examples of budget worksheets appear in the schedules throughout the chapter. Data Glamour Inc. produces and sells lady handbags. Below is information on its activities for the next few months. Sales projections...

how would one set up an excel spreadsheet and create a plot for electric force vs...

how would one set up an excel spreadsheet and create a plot for electric force vs the product of the two charges.

Given below is a fictitious Excel output (numbers might be all made up) Answer the questions...

Given below is a fictitious Excel output (numbers might be all made up) Answer the questions that follow. You are being tested for your ability to read the output and your skill in sensitivity analysis as taught in class.) Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$6 X1 45 0 12 10 8 $C$6 X2 0 -6 8 15 12 $D$6 X3 10 0 5 20 15 $E$6 X4 35 0 6 8...

1- State clearly the objectives of designing excel spreadsheet for retaining wall.

Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of...

Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion. Work in process, April 1—10,000 units: Direct material: 100% complete, cost of .........................................................................................................$ 22,000 Conversion: 20% complete, cost of ................................................................................................................. 4,500 Balance in work in process, April 1 ..................................................................................................................$ 26,500 Units started during April ......................................................................................................................................100,000 Units...

Please answer each question set on a separate Excel worksheet, labeled appropriately. (Include all formulas) Question...

Please answer each question set on a separate Excel worksheet, labeled appropriately. (Include all formulas) Question Set 1. You are in charge of quality control for computer monitors at Dell. You have data on twenty-five batches of monitors, tracking five types of defects: brightness, color, contrast, dead pixels, and stuck pixels. These data are given in the table below. 1. For each defect type, find the average number of defects per batch. So, you should have an average defect rate...

NSTRUCTIONS: This question contains three (3) parts. Answer all parts of the questions. Clearly label your...

NSTRUCTIONS: This question contains three (3) parts. Answer all parts of the questions. Clearly label your response to each part using bold text. For example: Part a): Your response... (a) Briefly outline two differences between futures and options contracts. (b) In August, a wheat farmer decided to hedge her entire anticipated 1,000 tonne wheat harvest with January wheat futures that were trading at a price of $290 per tonne. In January, the farmer harvested 1,000 tonne of wheat and sold...

INSTRUCTIONS: This question contains three (3) parts. Answer all parts of the questions. Clearly label your...

INSTRUCTIONS: This question contains three (3) parts. Answer all parts of the questions. Clearly label your response to each part using bold text. For example: Part a): Your response... (a) The weighted average cost of capital (WACC) can be calculated as where E is the market value of equity, D is the market value of debt, V = E + D, ke is the cost of equity, kd is the cost of debt and t is the tax rate. Briefly...

THIS IS ALL THE INFORMATION THAT I HAVE PLEASE ANSWER ALL QUESTIONS* *GOOGLE SPREADSHEET COULD BE...

***THIS IS ALL THE INFORMATION THAT I HAVE**** ***PLEASE ANSWER ALL QUESTIONS*** ***GOOGLE SPREADSHEET COULD BE SCREENSHOT AND UPLOADED**** Five processes, J1, J2, J3, J4 and J5. arrive in the Ready Queue in sequence, one second apart. Each job takes 1 millisecond to load into memory. Each job will take 10, 2, 3, 1, 5 seconds to run respectively. Questions A. Create a Google Sheet where each column represents a Job and reach row represents a second.. B. Show the...

Question