What is the answer for 6th question ?

B. Problem Statement You are projecting the purchase of a small restaurant in Kanata. The financial information on this potential investment includes: 1. Projected ownership of 4 years. Rental revenues before taxes of $600,000 at EOY1 increasing annually thereafter by $3,000. Annual expenses before taxes of $250,000 at EOY1 increasing annually thereafter by 2%. Today's asking price for the building is $950,000 with an expected selling price of $800,000 in 4 years. The Canadian income tax rate on this type of investment is assumed to be 40% (on profits before taxes, capital gains or losses, terminal losses and on recaptured depreciation). Buildings and equipment are to be depreciated using the DB method with a 15% depreciation rate. The half-year rule applies to the depreciation of capital assets. Working capital = $2,000. You will need a $550,000 loan at a 10% rate to finance, in part, your purchase and the required working capital. The loan is to be repaid as follows: EOY1 = 10% of the total loan EOY2 = 20% EOY3 = 30% EOY4 = 40% 10. The annual inflation rate is 1.0%. 11. MARRs are: Before-taxes with inflation = 15.0% Before-taxes without inflation inflation-free) = 14.0% After-taxes with inflation = 9.0% After-taxes without inflation (inflation free) = 8.0% BTCF = Before-Tax Cash Flow; ATCF = After-Tax Cash Flow; CFOE = Cash Flow on Owner Equity END-OF-YEAR (EY) | Cash Flows Anual revenues (AR) Actual ) Anual costs (AC) Actual $ 1. BTCF "Operations Actual 2. BTCF "SV" Actual 3. BTCF "Working Capital (Actual ) 4. Total BTCF (Actual) 5. BTCF "Operations" Constant $ 6. BTCF "SV" Constant) 7. BTCF "Working Capital" (Constant $) 8. Total BTCF (Constant 9. Annual Depreciation 10. Interest on loan 11. Taxable Operating Income 12. Taxes on Operating Income 13. Capital gains 14. Taxes on capital gains 15. Recaptured depreciation for terminal loss) 16. Taxes on recaptured depreciation or terminal loss) 17. ATCF "Operations" (Actual 18. ATCF "Operations" (Constant $) 19. ATCF "SV" (Actual) 20. ATCF "SV" (Constant ) 21. ATCF "Working Capital (Actual 22. ATCF "Working Capital (Constants) 23. Total ATCF (Actual ) 24. Total ATCF Constant) 25. (=R10. Interest on loan 26. Loan repayment 27.CFOE (Actual) 28. CFOE Constant) Questions Examples of rounding: $650 the nearest $100 becomes $700. $55,500 to the neatest $1,000 becomes $56,000. The dollar amount of cell AA (nearest 1,000) is a) 595,000; b) 606,000; c) 632,300; d) 647,000. The dollar amount of cell BB (nearest 100) is a) 265,300; b) 269,400; c) 272,200; d) 289,500. The dollar amount of cell CC (nearest 100 dollars) is a) 285,600; b) 317,900; c) 322,600; d) 345,900. The dollar amount of cell DD (nearest 100) is a) 785,600; b) 800,000; c) 825,000; d) 845,000 The dollar amount of cell EE (nearest 100) is a) -2,000; b) -1,800; c) 0; d) 2,000. The dollar amount of cell FF (nearest 100) is a) 329,100; b) 345,900; c) 357,600; d) 375,000. The dollar amount of cell GG (nearest 100) is a) 739,400; b) 746,000; c) 768,800, d) 816,900. The dollar amount of cell HH (nearest 100) is a) 1,900; b) 2,000; c) 2,100, d) 2,200. The dollar amount of cell ll (nearest 1,000) is a) 861,000; b) 973,000; c) 988,000; d) 1,101,000. The dollar amount of cell JJ (nearest 100) is a) 99,900; b) 112,000; c) 119,900; d) 132,100. The dollar amount of cell KK (nearest 100) is a) 49,500; b) 54,500; c) 78,800; d) 83,400. The dollar amount of cell LL (nearest 100) is a) 64,000; b) 69,900; c) 72,000; d) 78,100. 13. The dollar amount of cell MM (nearest 100) is a) 0; b) 70,000; c) 90,600; d) 102,800. 14. The dollar amount of cell NN (nearest 100) is