AutoSave On A 7. C G ... w Revised 2023 BSBTEC402 Student Assessment - Compatibility Mode - Saved to my Mac Q Search (Cmd + Ctrl + U) OF Home Insert Draw Design Layout References Mailings Review View Comments Editing v Share Arial v 12 A A Aav Ap IA AaBbCcDdE AaBbCcDdEe AaBbCcDdE AABBCCDDE AaBbCcDdEe Paste BI Uvab X X A DAY Bullet List Compliant B... Dot Points Heading 8 Inspire Body... Styles Dictate Sensitivity Add-ins Editor Pane Sample Output for 4 years Awesome Landscapes Pty. Ltd. 41455 2021 2020 2019 2018 Assets Cash and Cash Equivalents $1,360,000.00 $1,140,000.00 $1,220,000.00 $1,420,000.00 Account Receivable $2,100,000.00 $1,850,000.00 $2,200,000.00 $1,810,000.00 Inventory $273,000.00 $390,000.00 $355,000.00 $135,000.00 Work in Progress $1,840,000.00 $1,860,000.00 $1,830,000.00 $1,750,000.00 Total current Assets $5,573,000.00 $5,240,000.00 $5,605,000.00 $5,115,000.00 Non-Current Assets Plant and Equipment $2,750,000.00 $2,750,000.00 $2,750,000.00 $2,150,000.00 Plant and Equipment - Accum. Depreciation -$1,050,000.00 -$850,000.00 -$650,000.00 -$450,000.00 Total Non-Current Assets $1,700,000.00 $1,900,000.00 $2,100,000.00 $1,700,000.00 Total Assets $7,273,000.00 $7,140,000.00 $7,705,000.00 $6,815,000.00 Liabilities Current Liabilities Accounts Payable $1,220,000.00 $1,170,000.00 $1,120,000.00 $1,785,000.00 Bank Overdraft $250,000.00 $120,000.00 $75,000.00 $100,000.00 GST Payable $150,000.00 $80,000.00 $90,000.00 $210,000.00 Total Current Liabilities $1,620,000.00 $1,370,000.00 $1,285,000.00 $2,095,000.00 Non-Current Liabilities Loan Payable - Vans $300,000.00 $450,000.00 $600,000.00 $- Loan Payable - Cars $- $170,000.00 $250,000.00 $330,000.00 Loan Payable - Trucks $1,200,000.00 $1,300,000.00 $- S- Loan Payable S- $- $ - Loan Payable S - S- Loan Payable - 5 - S- Total Non-current Liabilities $1,500,000.00 $1,920,000.00 $850,000.00 330000 Total Liabilities $3,120,000.00 $3,290,000.00 $2,135,000.00 $2,425,000.00 Net Assets $4,153,000.00 $3,850,000.00 $5,570,000.00 $4,390,000.00 Owner's Equity Owner's /Shareholder's Capital $500,000.00 $500,000.00 $500,000.00 $500,000.00 Retained Earnings/Accumulated Losses $2,550,000.00 $2,360,000.00 $2,900,000.00 $1,380,000.00 Cash Sales $1,370,000.00 $2,410,000.00 $1,720,000.00 $1,210,000.00 Credit Sales $9,783,000.00 $8,400,000.00 $7,520,000.00 $6,020,000.00 Cost of Goods Sold $3,170,000.00 $2,890,000.00 $3,200,000.00 $2,890,000.00 Expenses $6,880,000.00 $6,930,000.00 $3,870,000.00 $1,830,000.00 Net Profit $1,103,000.00 $990,000.00 $2,170,000.00 $2,510,000.00 Total Equity $4,153,000.00 $3,850,000.00 $5,570,000.00 $4,390,000.00 Page 46 of 49 7970 words X English (Australia) & Accessibility: Investigate Focus E + 118%Autosave (D () & - @ Revised 2023 BSBTEC402 Student Assessment - Compatibility Mode Saved to my Mac ~ Q search (Cmd + Ctrl + U) o2 Home Insert Draw Design Layout References Mailings Review View (I Comments / Editing v (GBI o - o = T v Arial vz v|A A | Aav | A | =EviEv T AaBbCcDAE AaBbCcDdEe AaBbCcDAE AABBCCDDE AaBbCeDdEe 4 @J 00 # Raste P9 BE I Uva x, | Av 2w v T Bullet List Compliant B... Dot Points Heading 8 Inspire Body... Styles Dictate Sensitivity Add-ins Editor = 2 Pane Assessment: BSBTEC402 Design and produce complex spreadsheets TASK 3.4.3, 3.4.4, 3.4.5 BALANCE SHEET Using the same file, you created in Task 3.4.2, create a second tab and rename this tab as Balance Sheet. 1. On the Balance Sheet tab, produce a Four-Year Balance Sheet. 2. Automate this sheet using appropriate formulae to automatically populate the cells from the corresponding raw data imported into Sheet 1 (Task 3.4.2) from the .csv file provided. Include all data from the rows of \"Cash\" and \"Cash Equivalents\" up to the \"Retained Earnings/Accumulated Losses\". 3. Use the following definitions to produce the formulas for calculating the following for each e Total Current Assets Total Non-Current Assets Total Assets Total Current Liabilities Total Non-Current Liabilities Total Liabi Net Assets Total Equity = Cash and Cash Equivalents + Account Receivable + Inventory + Work in Progress = Plant and Equipment + Plant and Equipment- accumulated Depreciation = Total Current Assets + Total Non-Current Assets = Accounts Payable + Bank Overdraft + GST Payable =The Sum of all Loans Payable = Total Current Liabilities + Total Non-Current Liabilities = Total Assets - Total Liabilities = Owner's/Shareholder's Capital + Retained Earnings/Accumulated Losses 4. Label the table in this sheet as: Awesome Landscapes Pty. Ltd. Balance Sheet 5. Format this table according to the Awesome Landscapes Style Guide. 6. Save this file. Maintain the filename BSBTEC402 Task 3.4 Financial Summary. Page 46 of 49 7970 words X English (Australia) 7;'( Accessibility: Investigate (3 Focus - + 108%