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.

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 lohn Pasal 11! : !!!**: . INSERT Face . HOME Cut FILE PAGE LAYOUT FORMULA DATA REVIEW VIEW LU Da Copy - Calibri T N A Wrap Text Merge Center - Date $ U E % & 14A - Font fx year2 Conditional Formatos Cell Formatting - Table - Styles Paste - Format Painter Clipboard CAT : Insert Delete Format - - Alignment Numbri - Cells & F G H I Year 2 1/1 The bill for the 50 volumes of John's book is paid in cash. 1/2 Year 1 interest and taxes are paid in cash. 2/15 $20,000 from Year 1 services rendered is collected from clients. 3/1 Another year's worth of rent is paid in advance, but it has gone up to $12,600. 5/15 John purchases some antique accounting books and some framed "CPA" postage stamps from a retiring CPA for $500 cash. He contributes these assets to the firm. Entries f) through i) are summaries of activities for the entire year: summary The firm provides services to clients billable in the amount of $72,000. FS transactions horiz analysis Select destination and press ENTER or choose Paste Io Para HF -fel REVIEW VIEW AutoSum S. FILE HOME INSERT PAGE LAYOUT FORMULAS DATA 4 . Cut Calibri 14 ** = = - Copy Paste Format Painter A Clipboard Font CS4 X f r 2/15/2020 Wrap Text Center - M 5 % Conditional Formats Cell Formatting Table Styles Styles DE Insert Delete forma - - Clear Alignment G H Entries f) through i) are summaries of activities for the entire year: summary The firm provides services to clients billable in the amount of $72,000. 09 summary The firm collects $56,000 of the amounts owed from clients. summary Clients purchased 6 volumes of John's book, paying cash, at a price of $75 each. summary The business paid cash for administrative expenses of $15,000 still owed from Year 1 and for an additional $35,000 billed in Year 2. $5,000 from Year 2 remains unpaid. Entries i) through m) are adjusting entries made at the end of the year: j) 12/31 Depreciation expense is recorded for the furniture and equipment. (The memorabilia contributed to the firm in May is considered to be non-depreciable.) k) 12/31 Rent expense is recognized for the current year. FS + transactions horiz analysis Select destination and press ENTER or choose Paste 19 x