Question

lok - Excel DATA REVIEW VIEW FORMULAS - A A .A Weap Test 5. FILE HOME INSERT PAGE LAYOUT X Cut Calibri 14 Paste Format Painter BIU. . Clipboard Font A44 : x fc Y2 Autotum. A Copy D Conditional Format Formatting Table Sy E X insert Delete Format Sort & Find a Mergea Center Cel Styles Alignment KM NO LIABILITIES OWNER'S EQUITY CASSETS Furn. & Equip. Subtract Accum. Depr. Interest Payable Taxes Payable Note Payable Contrib'd Capital Retained Earnings Revenues Exp Prepaid Cash A/R Inventory Rent Scroll up to see the Year 1 horizontal analysis. A/P 44 Yr2 3,975 10,000 n/a 8,000 1,000 17,500 1,000 10,000 9,275 36,000 2,000 4,750 2,000 eg Bal FS transactions horiz analysis Seled destination and press ENTER or choose Raste

prepare a horizontal financial analysis for year 2 from the above entities.

those are yearly transactions which are supposed to be posted on the excel sheet provided.

Answer 1

Microsoft Excel - 2 X View M General File Home Insert Page Layout Formulas Data Review % Cut Calibri 11 AA = = = Ea Copy Paste B I U. Format Painter 3- E A E E * Clipboard Font P18 Wrap Text Merce Merge & Center - Center og 9 % % 0.0 .00 88 Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles AutoSum A Fill - Sort & 2 Clear Filter Editing Find & Select Alignment Number Cells Book1 © X A B C D E F G H I J K L M N O P Q R Prepaid Inventory Rent Furniture Acc. & Equipm Dep Interest Taxes Payable Payable Notes Expenses Contribut Retained revenues Expenses Payable Payable Capital Earning Cash A/R |A/P 6 Year 2 7 Beg. 36000 2000 3000 1000 17500 1000 3975 10000 10000 9275 2000 3750 8 a 9b -1000 4750 -3750 -1000 -3975 20000 -12600 0 -3975 0 -20000 0 12600 0 500 500 72000 56000 0 56000 450 - 15000 -35000 5000 1000 -2000 -2000 7875 32000 6250 12600 8000 20000 175000 0 10000 5000 10500 9275 K ™ Sheet1 Sheet2 Sheet30 0 0 Activate Windows Go to Settings to activate Window.. B0 100% u -+ A to a 4x ENG 14-01-2020 516 Ready 23:07 Type here to search