Lunar Artistry Company Projected Balance Sheet March 31, 2021 Cash Accounts Payable Accounts Receivable Mortgage Payable nventory Buildings & Equipment Common Stock Retained Earnings Total Assets Total Liabilities&Equity Projected BS Sales Budget Cash Receipt Budget Purchase Budget Cash Disbursement Budget Cash Budget Income Statement Statement of Equity Balance SheetA B C D E F G January 2021 February-21 March 2021 First Quarter Sales Beginning Cash Balance Add: Cash Receipts Less: Cash Disbursements Plus or Minus Other Items: 8 Ending Cash Balance 19 LB CO Projected BS Sales Budget Cash Receipt Budget Purchase Budget Cash Disbursement Budget Cash BudgetA B C D E F G January 2021 February-21 March 2021 First Quarter Sales Cash Payments from Inventory Purchases - Dec Cash Payments from Inventory Purchases - Jan Cash Payments from Inventory Purchases - Feb Cash Payments from Inventory Purchases - Mar Other Cash Expenses: Salaries Advertising Sales Commissions Total Cash Disbursements Projected BS Sales Budget Cash Receipt Budget Purchase Budget Cash Disbursement Budget Cash BudgetA January 2021 February-21 March 2021 First Quarter Sales Cash Sales Cash collections from credit sales Dec Cash collections from credit sales Jan Cash collections from credit sales Feb Cash collections from credit sales Mar Total Cash Receipts Projected BS Sales Budget Cash Receipt Budget Purchase Budget Cash DisburserA B C D E F G H K L M N P Lunar Artistry Company Projected Income Statement March 31, 2021 Revenue Expenses 15 16 17 18 19 Net Income 20 26 28 29 30 Projected BS Sales Budget Cash Receipt Budget Purchase Budget Cash Disbursement Budget Cash Budget Income StatementA B C D E F December 2020 Budgeted Cost of Goods Sold January 2021 February-21 March 2021 First Quarter Sales Plus: Desired Ending Inventory $ Less: Expected beginning Inventory $ = Purchases Projected BS Sales Budget Cash Receipt Budget Purchase Budget Cash Disbursement BudgetProjected Balance Sheet December 31, 2020 Cash $50,000 Accounts Payable 5180,000 Accounts Receivable 5270,000 Mortgage Payable 5300,000 Inventory 5154,000 Common Stock $500,000 Buildings & Equipment $626,000 Retained Earnings $120,000 Total Assets $1,100,000 Total Liabilities& Equity $1,100,000December 2020 January 2021 February-21 March 2021 Cash Sales $100,000 First Quarter Sales Credit Sales $400,000 Total Sales $500,000 Projected BS Sales Budget Cash Receipt Budget Purchase Budget Cash Disbursement BA B C D E F G H 1 J K L M N 0 P Q R Lunar Artistry Company Projected Statement of Equity March 31, 2021 Beginning Balance of Retained Earnings Add: Net Income Less: Dividend Ending Balance of Retained Earnings Projected BS Sales Budget Cash Receipt Budget Purchase Budget Cash Disbursement Budget Cash Budget Income Statement Statement of Equity
