Financia X adfs.uct x What's 1 x Free Ac X Downlo: x Choice ( X MU Breakev X My files x x Excel X x financia x Paraphr G dividenc x https://uctcloud-my.sharepoint.com/:x:/r/personalcbuzi001_myuct_ac_za/_layouts/15/Doc.aspx?sourcedoc=%7B44AA4026-OFB8-4C5F-85FB-A4.. ( Excel financial-statements-template - Saved Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Automate Help Editing Share Comments Catch up Refresh All E Queries Workbook Links iIll Stocks Text to Columns Flash Fill Ex Remove Duplicates Eo Data Validation D95 fx M N OP Q R S T u v W X Y Z AA AB 69 Total General and Adminstrative Expenses 1,238,785.00 37.8% 1,191,884.00 36.4%% 70 Total Operating Expenses ,283,285.00 39.1% 1,216,384.00 37.19% 71 72 Non-Recurring Expenses 73 74 Rewards and Gifts Given 256,000.00 7.8% 85,000.00 2.6% Software and Hardware Equipments 10,060.00 0.3% 1,010.00 0.0% 76 77 Total Non-Recurring Expenses 266,060.00 8.1% 86,010.00 2.6% 80 TOTAL EXPENSES 1,549.345.00 47.3% 1,302.384.00 39.7% 81 82 TAXES 83 Income taxes 26% 802,490.00 : 24.5% : 1,099.511.40 33.5% Dividends 87 88 89 TOTAL TAXES 802,490.00 24.5% 1,099.511.40 33.5% 90 NET INCOME 1000725.00 1912994.60 SHARE DISTRIBUTIONS 93 DIVIDENDS 94 95 Owner Dividends 500,500.00 15.3% 96 Shareholder Dividends 123,440.00 ; 3.8% 1,249,900.00 38.1% 07 = Balance Sheet Profit & Loss CashFlow CashFlowStatement + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 67% + financial-statem....xisx Show all XFinancia X adfs.uct x What's 1 x Free Ac X Downlo: x Choice ( X MU Breakev X My files x x Excel X x financia x Paraphr G dividenc x https://uctcloud-my.sharepoint.com/:x:/r/personalcbuzi001_myuct_ac_za/_layouts/15/Doc.aspx?sourcedoc=%7B44AA4026-OFB8-4C5F-85FB-A4.. ( Excel financial-statements-template - Saved Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Automate Help Editing Share Comments Catch up Refresh All ~ Queries Workbook Links iIll Stocks Text to Columns Flash Fill Ex Remove Duplicates Eo Data Validation D95 " X V f B D E F G H I J K L M N P Q R S T u v W X Y Z AA AB 80 TOTAL EXPENSES ,549.345.00 47.3% 1,302.394.00 39.7% 81 82 TAXES 83 84 Income taxes 26% 802,490.00 ; 24.5% ;1,099.511.40 33.5% 85 Dividends 87 88 89 TOTAL TAXES 802,490.00 24.5% 1,099.511.40 33.5% 90 91 NET INCOME 1000725.00 1912994.60 92 SHARE DISTRIBUTIONS/ 93 DIVIDENDS 94 95 Owner Dividends 500,500.00 15.3% 96 Shareholder Dividends 123,440.00 : 3.8% 1,249,900.00 38.1% 97 TOTAL SHARE DISTRIBUTIONS / DIVIDENDS 123,440.00 3.8% 1 1,750.400.00 53.4% 98 99 100 NET PROFIT 877285.00 26.8% 162594.60 5.0% 101 102 103 104 105 106 = Balance Sheet Profit & Loss CashFlow CashFlowStatement + Calculation Mode: Automatic Workbook Statistics Give Feedback to financial-statem....xisxFinancia X adfs.uct x What's 1 x U/ Free Ac X Downlo: x Choice ( X MU Breakev x My files x x Excel X x financia x Paraphr G dividenc X https://uctcloud-my.sharepoint.com/:x:/r/personalcbuzi001_myuct_ac_za/_layouts/15/Doc.aspx?sourcedoc=%7B44AA4026-OFB8-4C5F-85FB-A4.. [ Excel financial-statements-template - Saved Search (Option + Q) Back to workbook Showing 1 - 1 (for a total of 1 pages) Page setup BALANCE SHEET Print Current selection ASSETS Year 1 Year 2 Ignore print area Current Assets Paper size Cash $3,000.00 $2,000.00 Temporary Investments A4 (8.27"x11.69") $520.00 $520.00 Inventories $5,221.00 $5,221.00 Accounts receivable $15,666.00 $15,666.00 Orientation Prepaid expenses $8,000.00 $8,000.00 Portrait Other Total Current Assets $32,407.00 31.407.00 Page margins Fixed Assets Last custom setting Property, land and equipment $8,000.00 $8.000.00 Leasehold improvements Scaling Equity and other long-term investments Intangible assets Fit sheet on one page Less accumulated depreciation (Negative Value) -$300.00 $300.00 Total Assets $7,700.00 $7.700.0 Format options Pages (Print total: 1) Other Assets Deferred income tax Charity Goodwill Print Other Total Other Assets $0.00 $0.00 TOTAL ASSETS $40,107.00 $39.107.00 LIABILITIES AND OWNER'S EQUITY Current Liabilities Accounts payable Accrued wages and salaries Accrued compensation $500.00 $600.00 Short-term loans Income taxes payable financial-statem....xIsx Show all XFinancia X adfs.uct x What's 1 x U/ Free Ac X Downlo: X Choice ( X AM Breakev X My files x x Excel X x financia x Paraphr G dividenc X - CD https://uctcloud-my.sharepoint.com/:x:/r/personalcbuzi001_myuct_ac_za/_layouts/15/Doc.aspx?sourcedoc=%7B44AA4026-OFB8-4C5F-85FB-A4.. [ Excel financial-statements-template - Saved Y Search (Option + Q) Back to workbook Showing 1 - 1 (for a total of 1 pages) Page setup Other Total Other Assets $0.00 50.00 Print Current selection TOTAL ASSETS $40,107.00 $39.107.00 Ignore print area LIABILITIES AND OWNER'S EQUITY Paper size Current Liabilities A4 (8.27"x11.69") Accounts payable Accrued wages and salaries Accrued compensation $500.00 $600.00 Orientation Short-term loans Portrait Income taxes payable Unearned revenue $300.00 $300.00 Current portion of long-term debt Page margins Total Current Liabilities $800.00 $900.00 Last custom setting Long-Term Liabilities Scaling Long-term deb Fit sheet on one page Other long-term debt Total Long-Term Liabilities $0.00 0.00 Format options Owner's Equity Pages (Print total: 1) Owner's investment Accumulated retained earnings Print Other Total Owner's Equity $0.00 $0.00 OTAL LIABILITIES AND OWNER'S EQUITY $800.00 $900.00 FINANCIAL RATIOS Working Capital (Current Assets - Current Liabilities) $31,607.00 $30,507.00 Current Ration (Current Assets / Current Liabilities) $40.51 $34.90 Quick Ratio ((Current Assets - entories) / Current Liabilities $33.98 $29.10 Debt-to-Equity Ratio (Total Liabilities / Shareholders Equity) $0.0 $0.00 Long Term Debt-to-Equity Ratio (Long Term Debt / Shareholder 50.00 $0.00 financial-statem....xIsx Show all XPreview File Edit View Go Tools Window Help GHC 6 (1 8 57 9 9 8 0 Fri 21 Oct 00:52 O Off17231-2422-4360-9864-f41762293801 copy V 1 page - Edited v Q Search Hor The original document can't be changed, so a A duplicate with your changes has been created. X PROFIT AND LOSS Edi Close INCOME 2022 2022 as % 2023 2023 85 % of Sales of Sales Sales Revenue FORMAT Bookings 3,000,000.00 91.5% 4,000,000.00 122.0% LL Endorsments 110,000.00 3.4% 300,000.00 9.2% Merchandise 150,000.00 4.6% 160,000.00 4.9% Popup stores 18,000.00 ? 0.5% 17,890.00 0.5%% Total Sales Revenue 3,278,000.00 100.0%% 4,477,890.00 136.6% TTTT T Cost of Sales Marketing and Advertising 200,000.00 6.1% 200,000.00 6.19 Sound engineering 50,000.00 1.5% 50,000.00 E E Distribution 14,000.00 0.4% 14,000.00 0.4% Shipping 5,000.00 0.2% 5,000.00 0.2% Total Cost of Sales 269,000.00 8.2% 269,000.00 8.2% T AV Gross Profit 3,009,000.00 91.8% 4,208,890.00 128.4% Non-Operation Income OBJECTS Rental 7.500.00 7.500 Interest 5,000.00 5,500.00 Gifts and Donations Received 15,000.00 3,000.00 Other Income (awards) 50,000.00 4,000.00 Total Non-Operational Income 77,500.00 20,000.00 Edit Using.. TOTAL INCOME 3,086,500.00 94.2% 1,228,890.00 129.0%% EXPENSES SCANNED DOCUMENTS Operating Expenses Settings Marketing and Advertising Advertising 0.3% 10,000.00 0.3% Recognize text Direct marketing 4,000.00 0.4% 14,000.00 0.49% Total Marketing and Advertising Expenses 24,000.00 0.7% 24,000.00 0.7% Show bounding boxes Cancel Print Restrict editingPreview File Edit View Go Tools Window Help GHC 6 (1 8 42 9 9 8 0 Fri 21 Oct 00:53 O Off17231-2422-4360-9864-f41762293801 copy v 1 page - Edited Q Search Hor The original document can't be changed, so a A duplicate with your changes has been created X Wages and salaries 107,000.00 3.3% 107,000.00 3.3% Outside services Edi Supplies 70,000.00 2.1% 70,000.00 2.19% Close Meals and entertainment 40,000.00 1.2% 40,000.00 1.29% Rent 7.500.00 0.2% 7.500.00 0.2% Telephone 85.00 0.0% 85.00 0.0% Utilities 300.00 0.0% 300.00 0.0%% FORMAT Depreciation on sound equipment 4,000.00 0.1% 50,000.00 1.59 Insurance 1,000,000.00 30.5% 900,000.00 27.5% LL Repairs and maintenance 4,000.00 0.1% 5,000.00 0.5% Web site launch and Web Hosting 2.500.00 0.1% 1,599.00 0.09 Web site maintenance 2,000.00 0.1% 400.00 0.0%% ? Web site consultancy 1,400.00 0.0% TTTT T Total General and Adminstrative Expenses 1,238,785.00 37.8% 1.191,884.00 36.4% Total Operating Expenses 1,283 285.00 39.1% 1,216,384.00 37.1% Non-Recurring Expenses E E Rewards and Gifts Given 256,000.00 7.8% 85,000.00 2.6%% I= Software and Hardware Equipment 10,060.00 0.3%% ,010.00 0.09% I AV Total Non-Recurring Expenses 266,060.00 8,1%% 86,010.00 2.6%% TOTAL EXPENSES 1,549,345.00 47.3% 1,302,394.00 39.7% OBJECTS TAXES Income taxes 28% 802 490.00 24.5% 1,099.511.40 33.5% Dividends Edit Using.. TOTAL TAXES 902,490.00 24.5% 1,099,511.40 33.5% NET INCOME 1000725.00 1912994.60 SCANNED DOCUMENTS SHARE DISTRIBUTIONS / Settings IDENDS Recognize text Owner Dividends 500,500.00 15.3% Shareholder Dividends 123,440.00 3.89% 1,249,900.00 38.19 Show bounding boxes TOTAL SHARE DISTRIBUTIONS / DIVIDENDS 123,440.00 3.85% 1,750,400.00 53.4% Cancel Print Restrict editingFinancia X adfs.uct x What's 1 x U/ Free Ac X Downlo: X Choice ( X MU Breakev x My files x x Excel X x financia x Paraphr G dividenc X https://uctcloud-my.sharepoint.com/:x:/r/personalcbuzi001_myuct_ac_za/_layouts/15/Doc.aspx?sourcedoc=%7B44AA4026-OFB8-4C5F-85FB-A4.. [ Excel financial-statements-template - Saved Search (Option + Q) Back to workbook Showing 1 - 2 (for a total of 2 pages) Page setup For the Year Ending 31/12/2022 Print Cash at Beginning of Year 25,000 Current selection Ignore print area Operations Paper size Cash receipts from Letter (8.5"x11") Customers 705,000 Orientation Other Operations 10,000 Portrait Cash paid for Inventory purchases 264,000) Page margins General operating and administrative expenses (112,000) Last custom setting Wage expenses (123,000) Scaling Interest (13,500) [) Fit all columns on one page Income taxes (32,800) Net Cash Flow from Operations 169,700 > Format options Pages (Print total: 2) Investing Activities Print Cash receipts from Sale of property and equipment 3,650 Collection of principal on loans Sale of investment securities Cash paid for Purchase of property and equipment (100,000) Making loans to other entities Purchase of investment securities Net Cash Flow from Investing Activities (96,350) financial-statem....xIsx Show all XFinancia X adfs.uct x What's 1 x U/ Free Ac X Downlo: x Choice ( X MU Breakev X My files x x Excel X x financia x Paraphr G dividenc X https://uctcloud-my.sharepoint.com/:x:/r/personalcbuzi001_myuct_ac_za/_layouts/15/Doc.aspx?sourcedoc=%7B44AA4026-OFB8-4C5F-85FB-A4.. [ Excel financial-statements-template - Saved V Search (Option + Q) Back to workbook Showing 1 - 2 (for a total of 2 pages) Page setup Purchase of investment securitie Net Cash Flow from Investing Activities (96,350) Print Current selection Financing Activities Ignore print area Cash receipts from Paper size Issuance of stock Letter (8.5"x11") Borrowing Cash paid for Orientation Repurchase of stock (treasury stock) Portrait Repayment of loans (34,000) Page margins Dividends (53,000) Last custom setting Scaling [ Fit all columns on one page Format options Pages (Print total: 2) Net Cash Flow from Financing Activities (87,000) Print Net Increase in Cash (13,650) Cash at End of Year 11,350 financial-statem....xlsxFinancia X adfs.uct x What's 1 x U/ Free Ac X Downlo: x Choice ( X AM Breakev X My files x x Excel X x financia x Paraphr G dividenc X - CD https://uctcloud-my.sharepoint.com/:x:/r/personalcbuzi001_myuct_ac_za/_layouts/15/Doc.aspx?sourcedoc=%7B44AA4026-OFB8-4C5F-85FB-A4... [ Excel financial-statements-template - Saved Search (Option + Q) Back to workbook Showing 1 - 2 (for a total of 2 pages) Page setup Your Company Name Print 2 vear cashflow statements Current selection Ignore print area Cash at Beginning of Period 15,700 17,325 17,325 17,325 17,325 Cash at End of Period 17,325 17,325 17,325 17,325 17,325 Paper size Letter (8.5"x11") Operations Year 1 Year 2 Year 3 Year 4 Year 5 Orientation Cash receipts from Landscape Customers 57,767 Page margins Other operations Last custom setting Cash paid for Inventory purchases (22,000) Scaling General operating and admin expenses (9,333 [ Fit all columns on one page Wage expenses (10,250) Format options Interest (1,125) Pages (Print total: 2) Income taxes (2,733) Net Cash Flow from Operations 12,325 0 0 0 Print Investing Activities Cash receipts from Sale of property and equipment 2,800 Collection of principal on loans Sale of investment securities Cash paid for Purchase of property and equipment (6,250) Making loans to other entities financial-statem....xIsx Show all XFinancia X adfs.uct x What's 1 x U/ Free Ac X Downlo: X Choice ( X MU Breakev X My files x x Excel X x financia x Paraphr G dividenc X https://uctcloud-my.sharepoint.com/:x:/r/personalcbuzi001_myuct_ac_za/_layouts/15/Doc.aspx?sourcedoc=%7B44AA4026-OFB8-4C5F-85FB-A4.. [ Excel financial-statements-template - Saved Search (Option + Q) Back to workbook Showing 1 - 2 (for a total of 2 pages) Page setup Print Current selection Financing Activities Ignore print area Cash receipts from Paper size Issuance of stock Letter (8.5"x11") Borrowing Orientation Cash paid for Landscape Repurchase of stock (treasury stock) Repayment of loans (2,833) Page margins Dividends 4,417 Last custom setting Net Cash Flow from Financing Activities (7,250) 0 0 0 Scaling [ Fit all columns on one page Net Cash Flow 1,625 0 0 0 Format options Pages (Print total: 2) Print financial-statem....xisx Show all X