Question: Please create a cash flow diagram using excel and show all work for both Proposals! please and thank you i greatly appreciate it! Prop A

Please create a cash flow diagram using excel and show all work for both Proposals! please and thank you i greatly appreciate it!

Prop A Prop B \begin{tabular}{|c|c|c|c|c|c|} \hline MV(0) & 250,00 & $ & FC(0) & 1,000,00 & $ \\ \hlineFC(5) & 650000 & $ & FC(1) & 800,000 & $ \\ \hline Salvage & 50000 & $ & FC(2) & 200,000 & $ \\ \hlineAOC & 30000 & $/yr. & AOC & 8000 & $/yr. \\ \hline N & 10 & yr. & N & 25 & yr. \\ \hline Weed & 90000 & $/yr. & AOC Inc & 1% & \\ \hline Savings & 35000 & $/yr. & Savings & 35000 & $/yr. \\ \hline AOC Inc & 4.0% & & Savings Inc & 1.0% & \\ \hline Savings Inc & 1.0% & & Repair & 30000 & \$@ 5yrs \\ \hline & & & \begin{tabular}{l} Disposal \\ Cost \end{tabular} & 300000 & \begin{tabular}{l} \$@ EOY \\ 25 \end{tabular} \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please work using excel spreadsheet, and providing functions for review. Please and thank you, can you provide this quickly, greatly appreciate it. **The problems have already been worked, just need...

please solve asap this question is from Management course Your sister wants to startup a company that produces cupcakes for the farmers market. You are her management consultant. Details about the...

Please solve using Excel and show work thank you PROBLEM ONE (20 MARKS) Sales Cost of Goods Sold Selling and Administrative Expenses Advertising Expenses Depreciation Earnings before Interest and...

Please answer using excel and show work thank you! Answer the following questions. Please note: short-term investments are non-operating current assets; notes payable and short-term debt are...

8.1. Dulles Electric Company buys 1 million tons of coal annually to burn at its power plant. The company wants to invest in a unit train that will haul coal from the mine to the power house, where...

i just need to know how to do the excel sheets with formulas please. sorry for all of the pictures! im not positive whats important! thank you! this is everything i know Frenchies: Creating and using...

Using the link attach create a master budget. This assignment is to be submitted using an Excel XLS or XLSX workbook. Each budget schedule is to be contained on a separate spreadsheet tab. You are to...

Q1-Explain how the EBIT Chart works (inputs determining the outputs-the two lines on the chart Case Leahy Bread Company (LBC) in Cohen Finance Workbook, page 111( a 'caselette') SEE THE IS/BS MODEL &...

Prepare the financial analysis to support your decision between bankruptcy,voluntary reorganization,and Chapter11reorganization.It must be complete and prepared in a professional level,with the...

If someone could answer c,d, and e. I would really appreciate it. Thank you! 3. A Capital Budgeting Project Standard Food Company plans to establish a new production line for producing ice creams....

A 475-kg prestressed concrete beam is to be raised 10.0 m in 24.0 s. How many kilowatts of power are needed for the job?

Your first child was just born. Your parents tell you that they want to give your child a meaningful birth gift of their freshman year in college. Assuming that it will cost $35,000 to attend their...

Match each percentage change to the correct multiplier. In this exercise, always use a multiplier to calculate a percentage increase or decrease. The first one is done for you: A and ii A 50%...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

3 In view of the need to make the organization meaner, leaner and to give employees more flexible contracts, how can a company like DEC balance the instrumental needs of shareholders interests with...

1 What could be some of the problems if DEC tried to implement autonomous work teams, as they did in Scotland, in countries whose culture is higher in power distance and in uncertainty avoidance?...

2 What aspects of management and organizational learning are transferable from Anglo-Saxon countries to other countries?