Fill out the Q blanks for each row, with excel. Please show formulas as well.

2. Identify, comprehend and analyze the quantitative nature of the business problems in topies such as depreciation, inventory valuation/estimation, breakeven analysis, financial statements, ratio analysis, simple/compound interest/discount, annuities and amortization; A. Given the following X-Corp.'s financial information regarding their fixed (physical) assets, perform the following analysis by applying appropiate techniques/methods where necessary in C. Keep in mind uhat it is absolutely essential for you to figure out even the highlighted areas other than questions,though not directly asked, to correctly perform the task. The answer choices are Cost Salvage Value Life in yrs $ 31,000.00 $ 1,000.00 Weight Dep Amount(Expenso) 1/Life 1.25-2)-BV Depreciation Skdl Year BV YR Bea 1 31,000.00 2 $ 10,333.33 Depreclation Rate 66.67% 66 67% Depreciation Amount $ 20,666 67 $ 6,88889 Accumulated Depreciation $ 20,666.67 BV RYR End S 10,333.33 3.444.44 27,555.56 3 344444 a. 23,600.00 b. 17,962.22 .1.90 6667% s 2444 45 d. 30,000.00 e. 1,000.00 B. Given the following X-Corp.'s financial information regarding their inventory, perform the following tasks by applying appropriate techniques/methods where necessary in D. Keep in mind that it is absolutely essential for you to figure out even the highlighted areas other than questions, though not directly asked, to correctly perform the task. The answer choices are found at the end of the problem group Purchass Amount End In Amount C 35 S14.00 490.00 WAVG 80 $ 13.00 1,040.00 FIFO 60 $1500 900.00 LIFO 50 S 17.00 850.00 03 a5 Q7 04 06 Mar Apri Nov a. 1,179.00 b. 1,860.00 . 1,420.00 d. 1,997.16 .1,282.84