ome Insert Page Layout Heere 12 A Times New Roman c el Heading 11 Normal TI No Spadi. Heading 7 Heading Cut Copy Format Painter Dard BTU bu x x x Font Paragraph Question 1 (35 points): Aidan Norton owns Aidan's Lodge in a rural Midwestern town. His accountant is out with the flu and Aidan has to develop his balance sheet without his accountant's help. Using the following balance sheet accounts, help Aidan complete his balance sheet. Hint** the transactions must be listed in proper order. Please use Rachel's Balance Sheet below to compare the transactions and write them in proper order.** For example: it is Cash, then Marketable Securities, then Net Receivables (etc.) under Current Assets....proper order is necessary. Balance Sheet Accounts Investments Other Current Liabilities Building Accounts Payable Long-Term Debt 1,275,000 1,590,000 3,250,000 1,460,000 1,800,000 587,500 Paid in Capital Accumulated Depreciation Inventories Common Stock Retained Earings Land Net Receivables 3,000,000 1,185,000 380,000 750,000 2,865,000 1,957,500 Cash Furnishings and Equipment Notes Payable Marketable Securities 1.850.000 335.000 840,000 2,675.000 170,000 Other Assets Aidan's Lodge Balance Sheet December 31, 20XX Liabilities and Owners Equity Assets Current Assets Total Current Liabilities Total Current Assets Long-Term Liabilities Long-Term Debt Total Liabilities Property and Equipment Owners Equity Common Stock Paid in Capital Words: 489 SAM Dd AaBbcc AabbCel AaBbca AaBbCel AabbCcl AaBbca AABBCC AABBCC AABBCC AaBbcd 9 Subtle Em... Emphasis Intense E... Quote Intense Q. Subtle Ref... Intense R.. Book Title 1 List Para.. Styles A Strong Change Styles A Find - Replace Select- Editing Aidan's Lodge Balance Sheet December 31, 20XX Net Property and Equipment Retained Earnings Other Assets Total Owners' Equity Total Assets 11.800.000 Total Liabilities and Owners' Equity Question 2: Rachel owns a franchise restaurant of a large restaurant chain in New England. Help her calculate a vertical analysis of her balance sheet (35 points). Please calculate the all percentages for the Balance Sheet (vertical analysis) and then answer the questions (a through e) that follows. Rachel's Restaurant Balance Sheet December 31, 20XX S % Assets Current Assets Cash Marketable Securities Net Receivables Inventories Total Current Assets 57,317 130,769 80,000 34,545 302,631 248.837 Investments Property and Equipment Land Building Fumishings and Equipment Less Accumulated Depreciation Net Property and Equipment Other Assets Total Assets 206,053 418 665 205.556 135429 694.845 15,814 1 262 127 Liabilities and Owners' Equity Current Liabilities Arenamte Dahla 11 130 EB1009 ISUNG beat, AaBbc Heading 8 . Normal I No Spaci... Heading 7 Heading Painter Font Paragraph % Accounts Payable Notes Payable Other Current Liabilities Total Current Liabilities $ 142,439 31,905 147.907 322 251 Long-Term Liabilities Long-Term Debt Total Liabilities 218,272 540,523 Owners Equity Common Stock Paid in Capital Retained Earnings Total Owners' Equity 78.947 324,324 318 333 721,604 Total Liabilities and Owners' Equity 1.262,127 chel has been asked by her regional manager to compare her balance sheet percentages with the averages of the chain. Select percentages of the chain follow: Select Chain Percentages (Vertical Analysis) Cash Inventories Accounts Payable Notes Payable 6.70% 1.30% 10.50% 1.10% a. Compare Rachel's Cash % with the chain's %. Is it higher or lower? What might this mean? b. Compare Rachel's Inventories with the chain's %. Is it higher or lower? What might this mean? c. Compare Rachel's Accounts Pavable with the chain's %. Is it higher or lower? What might this mean? 489 SAME ng 9 Subtle Em.. Emphasis Intense E. Strong Quote Intense Q... Subtle Ref. Intense R... Book Title 11 List Para.. Change Styles Styles d. Compare Rachel's Notes Payable % with the chain's %. Is it higher or lower? What might this mean? e. In completing a vertical analysis of Rachel's Restaurant, what are some suggestions of improvement when looking at her Assets, compared to her Liabilities and Owner's Equity? EDO 100951 TMSUNG