help!!

Annie Rasmussen is the owner and operator of Go44, a motivational consulting business. At the end of its accounting period, December 31, 2018, Go44 has assets of $640,000 and liabilities of $230,000. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Doen spreadsheet Using the accounting equation and considering each case Independently, determine the following amounts, Round your answers to the nearest dollar. a. Capital as of December 31, 2018 $ b. Capital as of December 31, 2049, assuming that assets increased by $96,500 and liabilities increased by $30,000 during 2019, $ C. Capital as of December 31, 2019, assuming that assets decreased by $138,000 and abilities increased by $10,000 during 2049, $ d. Capital as of December 31, 2049, assuming that assets increased by $170,000 and liabilities decreased by $15,000 during 2049. $ e. Net income (ar net loss) during 2049, assuming that as of December 31, 2019, assets were $780,000 abilities were $270,000, and no additional common stock was issued or dividends pald. 1 Accounting equation Annie Rasmussen is the owner and operator of Go44, a motivational consulting business. The data for the assests and liabilities of Go44 at the end of its accounting period, December 31, 20Y8, are provided in the table below. Columns B and D indicate the increase (Inc) or decrease (Dec) in assets and liabilities from December 31, 20Y8. Calculate the corresponding amount for each 2 of the cases below. Consider each case independently. 3 4 DATA 5 Accounting Period Ended December 31, 20YE Assets $640,000 7 Liabilities $230,000 8 Using formulas and cell references, perform the required analysis, and input your answers into the amount column. Transfer the numeric results for the green entry cells (F12:F16) into the appropriate fields in CNOWV2 for grading. 10 11 Assets Llabilities Amount Formulas 12 A Capital as of December 31, 2048 13 S96,500 Inc $30,000 Ine B. Capital as of December 31, 2049 14 $138.000 Dec $10,000 Ine C. Capital as of December 31, 2049 15 $170,000 Inc $15,000 Dec D. Capital as of December 31, 2049 16 $780,000 $270,000 E. Net Income (or net loss) during 2049 17 9