Old MathJax webview

i need help on how to do Question 4 parts A, B, C, D, E, F, AND ,G

i need step by step explanation plus answer

4. Complete the Operating Cash Flow section to project the financial performance of the car wash from year 1 through Year 15. For each year, enter the revenue, operating expenses, depreciation, taxable income, the taxes due, and the net income from the car wash. a. Yasmin expects the car wash to generate $70,000 in Year 1 and $110,000 in Year 15. Calculate the revenue values in Year 2 through Year 14 assuming a linear trend. b. Set the expense of operating the car wash to $0 in Year 0, $25,000 in Year 1 and $50,000 in Year 15. Calculate the Year 2 through Year 14 values assuming a linear trend C. Calculate the initial Operating Profit (also called EBITDA (earnings before interest, taxes, depreciation and amortization)) for each year. d. Calculate the amount of depreciation using the Declining Balance depreciation (=DB) method. Use links to the Assumptions section to complete the formula. e. Calculate the EBT (Earnings before taxes) for the car wash in the next row. f. Enter a 37% income tax rate in the Assumptions section. Then calculate the amount of taxes owed for each year of the car wash's operation g. Calculate the Net Income from the car wash in Year 1 through Year 15. 3 4 Assumptions 5 6 7 8 9 10 11 12 13 NN 13 15 14 11 12 10 3 6 7 8 9 1 2 4 5 0 on 14 15 Forecast 16 17 Income Statement 18 19 20 21 22 23 24 25 26 27 28 Investment & Salvage 29 30 31 32 33 Forecast Cash Flow 34 15 13 14 1 11 12 2. 8 0 3 5 4 6 7 9 10 Sheet1 4. Complete the Operating Cash Flow section to project the financial performance of the car wash from year 1 through Year 15. For each year, enter the revenue, operating expenses, depreciation, taxable income, the taxes due, and the net income from the car wash. a. Yasmin expects the car wash to generate $70,000 in Year 1 and $110,000 in Year 15. Calculate the revenue values in Year 2 through Year 14 assuming a linear trend. b. Set the expense of operating the car wash to $0 in Year 0, $25,000 in Year 1 and $50,000 in Year 15. Calculate the Year 2 through Year 14 values assuming a linear trend C. Calculate the initial Operating Profit (also called EBITDA (earnings before interest, taxes, depreciation and amortization)) for each year. d. Calculate the amount of depreciation using the Declining Balance depreciation (=DB) method. Use links to the Assumptions section to complete the formula. e. Calculate the EBT (Earnings before taxes) for the car wash in the next row. f. Enter a 37% income tax rate in the Assumptions section. Then calculate the amount of taxes owed for each year of the car wash's operation g. Calculate the Net Income from the car wash in Year 1 through Year 15. 3 4 Assumptions 5 6 7 8 9 10 11 12 13 NN 13 15 14 11 12 10 3 6 7 8 9 1 2 4 5 0 on 14 15 Forecast 16 17 Income Statement 18 19 20 21 22 23 24 25 26 27 28 Investment & Salvage 29 30 31 32 33 Forecast Cash Flow 34 15 13 14 1 11 12 2. 8 0 3 5 4 6 7 9 10 Sheet1