Question: Week 8 Excel Spreadsheet to be used with the *actice Set: 2 Years 0 2 3 4 5 6 7 8 3 Acquisition stage cash

Week 8 Excel Spreadsheet to be used with the *actice Set: 2 Years 0 2 3 4 5 6 7 8 3 Acquisition stage cash flow: Initial Outlay (800,000) 5 6 Operating stage cash flow: Sales 600,000 600,000 600,000 600,000 600,000 600,000 600,000 600,000 8 Fixed Cost (220,000) (220,000) (220,000) (220,000) (220,000) (220,000) (220,000) (220,000) 9 Variable Cost (240,000) (240,000) (240,000) (240,000) (240,000) (240,000) (240,000) (240,000) 10 Depreciation expense (68 000) 68 000) (68 000) (68 000) 68 000) (68 000) (68 000) (68 000) 11 Taxable income 72,000 72,000 72,000 72,000 72,000 72,000 72,000 72,000 12 Taxes (20.160) (20.160) (20.160) (20.160) (20.160) (20.160) (20.160) (20.160) 13 After tax income 51,840 51,840 51,840 51,840 51,840 51,840 51,840 51,840 14 Add back depreciation 68.000 68.000 68.000 68.000 68.000 68.000 68.000 68.000 15 Operating cash flows 119,840 119,840 119,840 119,840 119,840 119,840 119,840 119,840 16 17 Disposition stage cash flow: 500,000 18 19 Total cash flow (800,000) 119,840 119,840 119,840 119,840 119,840 119,840 119,840 619,840 20 Present Value 872.591 21 Net Present Value 72.591 22 23

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 take sales up to $630,000 and down to $570,000 (up by 5% and down by 5%) and record the new net present value numbers. Returning to the original numbers, please take disposition value up to...

Using the spreadsheet provided, please run the following sensitivities: 1. Please take sales up to $630,000 and down to $570,000 (up by 5% and down by 5%) and record the new net present value...

1. Please take sales up to $630,000 and down to $570,000 (up by 5% and down by 5%) and record the new net present value numbers. 2. Returning to the original numbers, please take disposition value up...

**********Please answer question number 4*************** Using the spreadsheet provided, please run the following sensitivities: 1. Please take sales up to $630,000 and down to $570,000 (up by 5% and...

1. Returning to the original numbers, please take fixed costs up for all years to $231,000 and down to $209,000 (up by 5% and down by 5%) and record the new net present value numbers. 2. Returning to...

1. From the scenario, cite your forecasting conclusions that support TFC?s decision to expand to the West Coast market. Speculate as to whether or not the agency conflict discussed in the scenario...

Please review the excel sheets and recalculate Present Value Payback using 5.75%, then using 8.75% cost of money, and then using 11.75% cost of money. Please look at excel sheet to see how it show be...

Please calculate the Profitability Index, and the Present Value Payback. By using the 5.75% cost of money, an 8.75% cost of money and a 11.75% cost of money. What is the profitability index at 5.75%,...

Assignment - An Individual Assignment Use the assumptions, ratios and data provided to develop a forecast of the company financial statements for the next five 1 years (2019 to 2023) after preparing...

**********Please answer question number 6*************** Using the spreadsheet provided, please run the following sensitivities: 1. Please take sales up to $630,000 and down to $570,000 (up by 5% and...

Stone Incorporated's initial production department reported for April. units Direct Ingredients convert Completion Percentage Completion Percentage Getting started in process inventory 60.000 %60 %40...

You are given two unknown point charges, Q1 and Q2. At a point on the line joining them, one-third of the away from Q1 to Q2, the electric field is zero (Fig. 16-58). What is the ratio Q1/Q2? E =0 Q2

Variable costs are costs that: Multiple Choice vary directly with changes in activity. remain constant as activity changes. vary inversely with changes in activity. increase on a per - unit basis as...

Derive the time-dependence (7.25) for the imaginary channel of the demodulated and filtered signal signal. Fig. 7.3 The shifts in frequency for signals from a uniform sample due to demodulation and...

Providence Hospital has the following balances on December 31, 2024, before any adjustment: Accounts Receivable= $52,000; Allowance for Uncollectible Accounts = $1,500 (credit). Providence estimates...

Mayweather Auto Inc. (Mayweather) sold a new limited-edition SUV to Frakes Ltd. (Frakes) on June 1, for $170,000. The SUV has a normal selling price of $185,000 and thus the price charged to Frakes...

Costa Ltd is a company with a 30 June year end. The following information relates to Costa Ltd and its subsidiary Jumbo for the year ended 30 June 20.22. Property at cost Costa Ltd Jumbo Ltd Dr Cr Dr...

Misfitz Inc. is a small, private company specializing in non-dairy ice cream treats. Aurora and Lokee Pine, a married couple, are the owners of Misfitz and are very hands-on in the running of the...

Sunset Airlines is concerned about the level of service for its check-in procedure. Currently, a single clerk spends an average of three minutes per passenger checking luggage and issuing boarding...

2. Develop your own loop models for the following conditions. At least one model shall be developed for each of the points under (a-j) a) If A shows anger towards B, what will Bs reaction be? b) What...

1. To gain an understanding of the fact that relationships are something more than only cause and effect chains.

3. What is meant when we say that people with a Protestant character exhibit manipulative behaviour?