Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i just need the financial statement (last 3 photos) i have a lot of trouble getting it done 6 8 Jan 1 Data for Budget

i just need the financial statement (last 3 photos) i have a lot of trouble getting it done image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
6 8 Jan 1 Data for Budget Assignment Master Budget Case for Altec Manufacturing Inc 3 fiscal year end December 31 For the year ended December 31, 2022 5 estimated sales: in units) 20x1 70.000 Salesx1 20x2 80.000 Sales 2 9 20x3 90.000 Salesx3 10 11 price per unit 150,00 Price 12 13 1. Sales pattern 14 4% Jansales 15 Feb 4% Febsales 16 Mar 4% Marsales 17 Apr 10% Aprsales 18 May 6% Maysales 19 Jun 6% Junsales 20 Jul 9% Julsales 21 Aug 9% Augsales 22 Sep 3% Sepsales 23 Oct 11% Octs ales 24 Nov 15% Novsales 25 Dec 19% Decsales 26 100% 27 28 2 desired ending inventor finished ands) 38% Endetaret 38% EndFGtarget $ 28.000 Rentstorage 33.000 kirogram 55 DMkgperunit 0.85 DMpriceperkg 38% Ends sinvtarget $ 28 2 desired ending inventory (finished goods) 29 30 3. rental cost--Admn & Selling cost Seasonal 31 32 4. Raw material: SSA beginning inventory(raw materials) 33 required for each unit of product kg 34 cost per kilogram 35 36 desired ending inventory of SSA 37 38 Accounts payable payment pattern. 39 in the month of purchase 40 in the month following the purchase 41 in the 2nd month following the purchase 42 43 5. Purchase discounts in month of purchase 44 45 6. Beginning Accounts Payable: (on balance sheet) 46 November SSA purchases 47 December SSA purchases 48 49 7. Direct Labour 50 average rate of pay per hour 51 benefit rate percentage 52 Time to produce one unit minutes 53 54 8 per unit variable manufacturing 55 Lutilities 55% APpaymontho 25% APpaymonth 1 20% APpaymonth2 2% AP discounto $ $ $ 227.800 450.500 PurchSSANovxt 306.000 PurchSSADecx1 rate with benefits 24 20.00 DLpayrate 20% Dibenrate 75 DLperunit (convert to hours) 125 12.00 OS D E 75 DLperunit (convert to hours) H 1.25 12.00 5,00 4.50 59 1,95 2.50 25.95 VOHperunit B 52 Time to produce one unit minutes 53 54 8. per unit variable manufacturing 55 Utilities 56 Indirect materials 57 Plant maintenance 58 Environmental fee Other 60 61 62 9a. Actual fixed manufacturing overhead costs for last 12 month year 63 training & devel $ 64 property/bus tax (see 9b below) 65 supervisor's salary 66 amortization 67 insurance 68 other 69 $ 70 71 9b. Expected property taxes for next year $ 72 73 9c. Expected insurance premium for next year Apr 1. Mar 31 $ 74 75 76 10. cost per unit previous year (201) Absorption Costing $ 77 78 11. Selling and Admin 47.520 FMOH trainx1 36.000 FMOH proplaxi1 89.400 FMOH_salaryx 1 227.760 FMOH amortx1 92.460 FMOH_insurancex1 109.600 FMOH_other 1 602.740 39.000 FMOH_proptax2 93.300 FMOH_Insurance 2 93,90 TotalCostperunitx1 G H 77 78 11. Selling and Admin total operating Units expenses 42.500 $ 1273,123 87.500 $ 2493.073 Per unit $ 27,11 $120.948 or $ 10.079 per month 21,0% Salescolo 42,0% Salescoll1 35.0% Salescoll2 2,0% BadDebts $ 1.100.000 Sales Nov1 $ 1.600.000 Sales Dec 79 80 Lowest level of sales 81 Highest level of sales 83 12 Sales collection pattern 84 current month 05 following month 86 2 months after 87 uncollectible 88 #9 12. Beginning accounts receivable (on balance sheet) 90 November 20x1 Sales 91 December 20x1 Sales 93 14 Income taxes 94 Monthly tax installments 95 Income tax rate 96 97 98 15 Capital asset purchase (capital budget) 99 payment payment 101 102 16. Dividends (capital budget) 103 conduicalonda cuador Data Sales B Cash Call Prodin 10.000 Taxinstalimo 25% Taxate 304.750 Assetpurchase 40% Assetpay1 60% Assetpay Apr May 100 DM Cash Dish 32.000. Dimerouarter MOH COGMR COGS S&A XD E F per annum $ $ 15.000 Mincashbalance 5% interestrate 1.000 borrowrepayblocks $ B 04 05 17. Bank credit arrangements 06 Minimum balance required 07 rate of interest 08 borrowing and repayment blocks 39 10 18. Opening balance sheet 11 Cash 12 Accounts receivable 13 Inventory-raw materials 14 Inventory-finished goods 15 Prepaid insurance 16 Capital assets (net) 17 18 19 Bank loan payable Accounts payable 21 Income tax payable 22 Capital stock 23 Retained earnings 24 25 26 27 $ 15.680 Cashbegin 1.617.000 Arbegin 28.050 InvRMbegin 28.170 InvFGbegin 23.115 Prepaidinsurbegin 1.328.000 NetCapitalAbegin $ 3.040.015 TotalAbegin 20 $ 102.000 Bankloanbegin 227.800 Apbegin 11.200 Inctaxpaybegin 1.200.000 Capstockbegin 1.499.015 Rebegin $ 3.040.015 28 29 30 24 Data Sales & Cash Coll Prod'n DM & Cash Disb DL MOH COGM & COGS S&UA B C D Altec Manufacturing Inc. Sales Budget For the year ended December 31, 2022 Feb Mar Apr May Jun Ang Sep OCE Nov Dec 4 4 109 119 19 19 3200 3200 3200 8.000 4800 4.800 7200 2.400 8.800 s 12 000 15200 15000 150003 150.00 150.00 150,00 15000 150.00 15005 190005 15000 190,00 5 15000 54000400 3400 00000 51200 000,00 5 720 000,00 3 720.000,00 51.000.000,00 $ 100.000,00 30.000,00 $100 000,00 32 200.000,00 Year 80.000 Percent of Anu Sales 7 Expected sales ante Selling price per un Budgeted Revenue 1000 17.000.00 Altec Manufacturing Inc. Schedule of Bad Debts Expense For the year ended December 31, 2022 Jun Aus 14400 21.00 2100013 Feb Sep Now Dee 16 Uncletelepon Api 24.000 Oct 22.4003 0.0001 240 000 Colections from Current Sales an 100 000 472.000 Sales & Cash Coll Altec Manufacturing Inc. Schedule of Expected Cash Collections For the year ended December 31, 2022 Feb M May Jun al Sep NO 10000 10000 252000 15120025 151200 2200 22005 7500032772003 370003 20161 1010001 5040 743 4516 51.63 151200 SSL Prod DM & Cash Onb DI MOH COGM & COGS SAA exp 10 67005 Year 2.520.000 4154499 Data Dec total 7701 1785.000 2.385 600 ALTERNATIVE SHEDULE OF CASH COLLECTIONS alebe as the same Altec Manufacturing Inc. Schedule of Expected Cmh Collections For the year ended December 31, 2022 Apr JUR Jul made in Jan Feb Mar Sep Oct Dec 672.000 3 100003 S 201400 38000 100.000 2010003 100.000 5 Year 56000 1 232 000 470 400 470 400 410400 1.000 100.000 2016005 168000 104.000 151300 000 20 000 302400 1512001 1 212.000 200 226 000 202001 453000 226.00 38000 453600S 75.6003 $ 316 000 151 2005 217 2009 126000 1544001 378600 701 600 1460 10500 982.300 1293 600 1.134.000 478.00 462 000 754.000 478.00 115710 200 6.00 76100 TOT 200 1052400 Data Sales & Cash Call Prodin DM & Cash Dis DE MOH COGM & COGS S&A Exp. To B J M N 0 P F G H Altec Manufacturing Inc. Production Budget For the year ended December 31, 2022 Feb May Oct Mar 3200 3.200 Apr 8000 4.800 Sep 2400 8.800 Nov 12.000 Dec 15200 Year 86.COD Jan 3200 121 4496 Jun 4800 2.73 7.536 Jul 7200 2730 9998 Aug 7.200 012 8.112 Feb 20x2 2600 30 188 2968 1216 4416 1024 9024 1324 6.824 3344 5744 4560 13.300 5.778 17.776 13 15.00 1368 31.300 6240 6 Budgeted an uns Add desred ending inventory of ished goods Total de Less being inventory of 9 fied 10 Recured groduction 1 12 13 1216 300 4.116 3040 8.784 300 1244 5004 3200 1024 5712 2724 7200 912 4312 27% 5378 300 81068 4.800 18.618 13210 10.792 3600 15 16 17 * &N Data Sales & Cash Coll Predin DM Cash Disb DK MOH COGM & COGS SA EXP B D M 0 Altec Manufacturing Inc. Direct Materials Budget SAA kilograms For the year ended December 31, 2022 Feb Aug 53 Sep 4833 Nov 13216 Year 81 061 21 3.800 4118 40 226 380 205 18.000 Mar 5024 25 270320 1TM 18.00 105.000 313.114 unts to be produced Raw Weeper Production neede Add desired endng every 10 Total de 11 Loss Beginning inventory 12 raw materials to be purchase 13 14 Cota SAA mer 15 Cross cost of purchases of SAA Apr 6784 SS 5730 10030 472.440 1417 331654 May 4800 55 254 000 1931 383301 100 320 283001 Jul 7200 45 290.000 117350 500.550 55 178000 1000 2010 00 214122 5712 3 314100 144.400 4640 119.361 345250 2050 100 T280 2250 Oct 1001 95 580300 278214 2704 209 334 6170 200200 33.000 200 260 Der 10.79 5. 383560 33.000 6500 225.553 491007 209354 474004 100 900 374101 4.458 1641297 &4000 1441297 4458740 112 364 204310 2214 357.18 1.210 0.85 0.85 221 221 085 182.003 0.85 DAS 208.530 201300 DES 240.000 Des 233410 OBS 304101 0.05 2014 305 317.00 0.85 574.00 0.85 3401 0.85 3.789.529 17 SERRNI Altec Manufacturing Inc. Schedule of Expected Cash Disbursement for Purchases of Raw Material SAA For the year ended December 31, 2022 JA Feb Mar Apr Aug Sep 121672 1 100 1023 14.378 1 155.046 332 331 1101409 3107.300 132015 1 174094 1 2003033 Sales & Cath Col Prodin DM & Cash Dib ON MOH COGM & COGS SHI V sim ped for Curre How 16.132 1 Der Year 17.0 32.084469 Data 16 17 18 19 20 Altec Manufacturing Inc. Schedule of Expected Cash Disbursement for Purchases of Raw Material SAA For the year ended December 31, 2022 Nov 316.1325 2647 22 Paid for 23 Current month's purchases 24 Less purchase icon Het payment Per month's purchases 27 Two months prior purchases Totalcar dabursements for parchases of raw material Jan Feb Mar Apr May Jun 121.872 100 1025 148.378 $ 155 048 $ 132 381 $ 151 409 $167308 3 2.433 3.100 3.22 3.346 119239 98100 16440 151 947 129.684 158.181 1632 76.500 29.810 24 125 35 37 30.545 10.100 30.677 5 2434 20 020 5 23275 3 31010 5 26.400 5 132.915 5 2658 130257 40991 322623 Sep 1748945 3498 171396 12564 334623 Oct 288 8035 5778 283 027 12.840 205635 300 300 70.757 Dec Year 187 471 5 2084 461 3749 41 609 183.722 2042772 341263 57781 1 436945 146 329 15 Lp t2 201 200 199 198 199 271 17 29 973 237 422 352459 415.5453 318.505 5 3020969 Altec Manufacturing Inc. Schedule of Ending Accounts Payable For the year ended December 31, 2022 Amon 114 057 More Nova Dec to 20N 45 Data Sales & Cash Coll Prodin OM & Cash Dish DE MOH COGM ACOGS SA exp CT D Altec Manufacturing Inc. Schedule of Ending Accounts Payable For the year ended December 31, 2022 Hone pad 20 455 Amount 114 957 1535 S 266142 Dec2 38 39 42 Altec Manufacturing Inc. Schedule of Ending Raw Materials Inventory For the year ended December 31, 2022 44 46 47 Kenge per budget Price per Couter ending raw materiais ventory 1641257 85 $ 1396. 102 49 50 51 ALTERNATIVE SCHEDULE OF CASH DISBURSEMENTS FOR PURCHASES alle rentans the same 54 Altec Manufacturing Inc. Schedule of Expected Cash Disbursement for Purchases of Raw Material SAA (Alternate) DM & Cath Disb DL MOH COGM & COGS SBA exp Data Sales & Cash Col Prod B N 51 52 D ALTERNATIVE SCHEDULE OF CASH DESURSEVENTS FOR PURCHASES at remains the same Altec Manufacturing Inc. Schedule of Expected Cash Disbursement for Purchases of Raw Material SAA (Alternate) For the year ended December 31, 2022 Apr Feb 2002 Aug Dec Mar 29201 Jan 1243011 10100 78500 May (2.6471 Jun 0.220 346 Oct 65.778 (1490) Now 16.323 749 61 200 55301 1001 54 55 50 57 58 Purchase decount 69 Atroverb 60 AP from December 61 62 Feb 63 64A 65 y GO GM GOA 69 Sep 70 od 171 72 Des 4 45501 14 3841 35 155.040 - 53220 70 477 56.341 00.150 101.400 40120 73 6700 Year 151023 90 100 137700 221 221 2003 206130 281.900 240603 23 304137 201604 3170 52509 50.821 18771 3.109205 S6094 7604 132015 6681 60414 11484 4330 75 407 288.803 136274 310.14 195019 143 187471 4324T 215 33 2140 223.192 25462 25330 2747 205 450 205.000 292012 4100 104.561 14 Data Sales & Cash Col Pron DM & Cash Disb DL MOH COGM ACOGS S&A expi Altec Manufacturing Inc. Direct Labour Budget For the year ended December 31, 2022 4118 5024 Year 81068 51.25 unts to be produced 8 Direct Labour time per un hours) Total hours of direct labour me needed 10 Dreabour cost per hour 11 Total direct labour cost 12 Feb Mar Ape May 3.200 8.754 125 1.22 1,20 1.25 125 3.145.00 4.000.00 6280.00 8.400.00 6.000.00 2400 2400's 2400's 2400's 5123430 S 96.000 5 150720 5 203 520 144000 Jun Aug Sep Oct Now Dec 5.712 7200 5378 10 016 13216 19792 1.23 1.25 1.25 123 125 128 7.140.00 9.000.00 6.720.00 6.040.00 12.520.00 16.520.00 13.490.00 2400 2400's 2400 2400 2400 2400's 2400 171.360 5 216 000 161.2805124960 $ 300.480 396.480 323.750 101 33500 2400 2400 2432040.00 14 15 16 17 18 19 20 INNS Data Sales & Cash Col Prod DM & Cash Dish DL MOH COGM & COGS S&A exp Se con el destino y present ENTRAR O papegar Altec Manufacturing Inc. Manufacturing Overhead Budget For the year ended December 31, 2022 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Year Production in Units 4.116 3.200 5.024 6.784 4.800 5.712 7200 5.37 4832 10 016 13216 10.792 81.068 Variable overhead rate per un 5 25.955 2595 5 25.955 25.95 $25,955 25.955 25955 25.955 25955 25.955 25,95 52595 Variable manufacturing overhead 105.9.10 3.49 2.139.372 $175.045 124.560 148725 3185.848 132.597 125,390 2.259.915 242.955 289,052 52.109.715 99.000 10 Faed manufacturing overhead 11 Training and development 3.960 3.900 3.960 2960 3.900 3.960 47 520 12 Property and businesses 30 000 13 Supervisor Salaries 7.450 7.450 7450 7.450 7450 7.450 7.450 7.450 7450 7.450 7.450 7.450 89 400 14 Amortization on ecupent 15 nurance 93.300 93 300 16 Other 133 9.139 9133 9.133 9.133 9133 9133 9133 2133 9.133 9.133 9.133 109596 17 Totalfixed manufacturing OH 2034 20.500 20.542 20542 20.30 20.542 2059 0843 20.542 378 816 18 19Total manufacturing on 12735) 1032 10.01 200.000 145.103207.2005207309 3160050 145.933 3280458 3.263.409.300505 32.482531 20 21 22 Altec Manufacturing Inc. 23 Schedule of Expected Cash Disbursement for Manufacturing OH 24 For the year ended December 31, 2022 Data Sales & Cash Coll Prodh OM & Cash Dish DL MOH COGM & COGS S&A exp B C 103.583 D E 150.256288888 = 145.103 19 Total manufacturing on 20 G 207.789 H 207323 S 180050 145.933 K L M N 280 490 5363.40 $300.595 52 482.53 Altec Manufacturing Inc. Schedule of Expected Cash Disbursement for Manufacturing OH For the year ended December 31, 2022 Feb Jul Apr Jan 127.353 Sep Oct Mar 150916 Aug May 145.103 Jun 207768 Now 36348 14533 Dec 300 595 Year 2482531 100.050 3.250 7705 3.250 3250 3.250 7.705 18.900 3250 7.705 18.900 3.250 7705 18.900 7705 3250 7705 18.980 1701 3.250 7.705 18.900 3250 7705 18.980 3.250 7705 18.880 3.250 7.705 18.900 3250 7.705 18.900 29.000 2460 227.780 18.950 18.900 18.900 Total manufacturing Oh for month Noncash property tax insurance 31 amortization Monthly cash disbursements for 32 manutacturing OH 33 Lumum payments 34 property tax 35 urance Cash disbursements for manufacturing OH * 97.418 73.648 120.901 259.963 115.166 177.834 177.448 130.115 115.990 250.523 270.000 2123.311 39 000 99 300 $ 97.418 5 73.648 3 120.961 5353253 3 115.168 3.296.834 177446 S 130.115 $115.990 3 250.523 5 33.563 $ 270,000 $2.123.311 41 Altec Manufacturing Inc. Schedule of Prepaid Insurance For the year ended December 31, 2022 DM & Cash Dish DL MOH COGM & COGS Data Sales & Cash Coll Prod'n SBA exp B K 37 38 39 10 Altec Manufacturing Inc. Schedule of Prepaid Insurance For the year ended December 31, 2022 42 May 23105 Now 23115 Jan 23115 705 15 410 Feb 23115 -70 15.410 Mar 23115 0705 15410 Apr 23115 3.705 15.410 93.000 106 410 Jun 23115 1705 15410 23115 1.705) 15410 Aug 23115 7.70 15.410 Sep 23115 0705 15410 Oct 23115 705) 15410 Dec 23115 1.705 15410 Year 277.300 192.460) 184.120 93 000 15.410 14 Balance at beginning of me 15 persed during the month 46 Balance before premium paid 7 Premad 48 tancat end of month 49 50 31 15.410 15 10 15 410 19.410 15,410 15.410 15.410 15410 35.410 11 410 15.410 15.410 56 58 30 Data Sales & Cath Coll Proda OM A Cash Dib DL MOH COGM COGS SHARP II B IGDE M N G Altec Manufacturing Inc. Cost of Goods Manufactured Budget For the year ended December 31, 2022 ins Jan 4110 Feb 3200 Mar 5024 ADI 8.784 Jun 5712 Jul 7200 Aug 5378 Sep 4812 Oct 19 016 Now 13210 4800 Dec 1072 Year BIAR Production in OM used in production (from DM schedule 9 DL ded to producten (trom DL schedule 10 Variable ValutOverhead (om On sched 11 Foed manut Overhead (om o schedule 12 Totalcoou 192.423 123480 108 810 20.54) 149.000 DOO 83.040 214.872 150720 130373 317152 203.520 178045 113.843 IDEO 224.400 144.000 124560 20.54) 17130 145 226 59543 33600 256.000 1865.840 20 543 504520 323160 280 052 20 543 1.1271 3.709.929 2.432 04 2.103 713 378.816 12 251320 22:50 468 248 617 348 161230 14400 300.450 10 129 507 125.300 250.915 342.955 20543 20.543 20.543 20543 123 EMEND Producten on perust for the ye Congot DM Con perunt DL perut VOH cost peront FUO Golper 100 100 4750 30 000 25.50 7400 110,10 Altec Manufacturing Inc. Ending Finished Goods Inventory Budget (Absorption Costing) For the year ended December 31, 2022 Costa Proan DM & Cash Dib DL MOH COGM & COGS SA EXPO Data Sales & Cash Coll FLOH cost perut 7.480 110,100 Altec Manufacturing Inc. Ending Finished Goods Inventory Budget (Absorption Costing) For the year ended December 31, 2022 Cost of ending Fonvertory end of year Unts ning inventory Total cost perut Total cost of ending very 27 1360 110,180 150728 25 Altec Manufacturing Inc. Cost of Goods Sold Budget For the year ended December 31, 2022 Beginning inventory Cost of Goods Manufactured Cost of goods available Ending inventory Cost of Goods Sold 28170 8704500 8.732070 150720 8581944 39 40 21 431 44 Data Sales & Cash Coll Prodin DM & Cash Desb DL MOH COGM & COGS S&A exp + B M N Altec Manufacturing Inc. Selling and Administrative Expense Budget For the year ended December 31, 2022 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Now Dec Year 6 Budgeted sales is units 3.200 3.200 3200 8000 4.300 4.800 7 200 7.200 2.400 8.300 12.000 15200 (30.000) Variable selling and administrative 7 expense perunt $ 27.115 27.115 27/115 27/11 27 11 27.11 5 27.11 5 27/115 27 11 3 27/115 27,115 27.115 27.11 8 Variable expenses 5 00752 5 16.7525 4752 3 216880 5 130 120 5 130126 5 196.1925 195.1925 $5.004 5 238.560 5 325 320 5 412072 2.168.800 wedseling and administrative 9 expenses 10.079 10.079 10.079 10079 10010 10.079 10019 10.079 10.079 10.079 10079 10.070 120.948 10 Les puchons de contain 2433 2.002 2.925 0.1013 2647 346 (3.450 6.223) 3749 11 94300 4629 99903 223 058 137560 198979 201425 202 613 7845 242871 399076 418403 2.248010 12 Pu Bad Debt 9.600 9600 9.500 24000 14400 14400 21 600 21000 7200 26.400 35.000 45 600 13 Warehouse rental 240 000 28 000 28 000 21000 28 000 112.000 Total Budgeting and 14. strive expenses 110200.11.2010350430211111170224712MS129277129.07.402.0022800050 15 16 17 10 Altec Manufacturing Inc. 19 Schedule of Expected Cash Disbursements for S & A Expenses 20 For the year onded December 31, 2022 21 22 Jul Aug Oct Yenc Sales & Cash Coll Prodin DM & Cash Dish BL MOH COGM & COGS Cast SBA exp Altec Manufacturing Inc. Schedule of Expected Cash Disbursements for S & A Expenses For the year ended December 31, 2022 16 17 18 19 20 21 22 23 Budgeted $ & A expenses 24 Lesson-cashem 25 Purchase discounts taken Baddest expense 27 Jan Feb Mar Apr May Jul Aug Sep Oct Now Dec Year $ 103,98 $ 104 429 $ 103.503 S 247 858 5 151.960 S 151379 $ 223525 $ 224213 5 106.845 5 297.271 $ 399 078 $ 492002 $2.600.059 2233 2002 2920 3.101 2647 3.228 3.346 2.650 3.490 5.776 6.323 3749 (9600) 41 689 0.000 19.600) (24 000 (14.400 (14.400) (21.600) 7 2001 26.400) (26000 (45000) (240 000) 595 631 33831 06.831 5 226.9 140 207 3 140 207 5 205 271 3205 271 3 103.14) $ 276.647 $ 369,399 $450 151 $2.401.740 21.600 J2 33 34 35 39 Sales & Cash Coll Prod'n DM & Cash Disb DL MOH COGM & COGS S&A exp 13.000 10 W HKS Cash Beginn Adres Collection from Totalcash valle Les durante Director Dred Wabunge Sedie Altec Manufacturing Inc. Cash Budget For the year ended December 31, 2022 Mar Apr May Jun Jul Aug Sep Ot Now Dec Year 15.60 54576 72293 583123 47964473830 $ 1703 317 100 3 197 3363 16.07 $92 209316052213 727534 1 157.000 982400 470 400 621800 23 200 1200 200 92200 100 400 1896.300 S 9400 117340 3190 1 282705 17912 75524 624012 615294 70974 270125 CI 79 S 102630 2 (156) (162301 207020 (1 221 612 02931 20320 237492 3-5 3.020) 112360 52.450 0001 (150720 203 20 (146000 (171 96.0001 (901200 (1440) (300400 480 (323700) 5 2430.040 14 (73643 130 253 253 (116101 1034) (1774401 (130111 (1169900 250 523 GO 2205 031 033.500 1830) (10301 1140207 2052711 205 21 110110 766) 33 11000 (10.000) 45015112401748 (10 000 ( 1000) 110.000 1000) 110 000 (10000 100001 111300 -3 1120 100 1121600) 5304754 1200 1200 30 1200013 120000 201 1010 144 12 20 DONOSTI.COR.10079432 115.000 0.000 1.00 1.000 0.000 13.000 (1000) 1 03 30 362001 10000 10 Wergente Cape 10 Dividere Tower 2 bed 000 100 David su The cel med SRR Panon Borrowed Prod's OM Cash Dicb DL MOH COGM & COGS Shap Cash Budget Projecte... o Cash balance beginning Addre Colection homoutomer Totalcahualable 10 Less dsbusser 11 Dec 12 Dolabow 13 Marudungveld 14 Seling dative expenses 15 hoone Testamente 10 Table 1 hestesented monthly 10 Capuchases 19 Dudendo Touldisbursements 21 Muncachacer Encere ideiciencylo cash before D E H Jan Feb Mar Ape May Jun Ad Aug Sep Den New Dee Year 6.600 1457407 3702306 353632 - 6754-136350 - 70 - 37.06 - 37320 -5 38079 - 522209 -1008221 - 1152.00 2400 470 400 6216.00 3200 TO 7910 201200 5.400 1058 400 16.0991400 1173.480 1319 881 125276 1.157932 255.246 737 250 624012 703.814 77023 536.199 611572 110.263.066 1 (205.839 [158 587 132307 12078290 (136.346) 12216121 (229.973 (203.5253 1237.4223 (352 4531 1415.545) 36601 (318.935) - 3020 983 198.000 11507203 23.5.200 14.000 (1713001 11612801 IN 6300 4501 1390400 1-1 2432040 137.41 73.648 20.305 1353 2530 115. 126.8341 1777 4480 136031 1961 1130 1951 250 5231 13335631 270.680 2255.671 196 0911 12289590 10207) NO 2071 1205275 1205271 10343 1383 3991 0.0001 0.0001 100001 276.6471 110.000 10.000 145061 - 2401 748 110.000 0.0001 10 000 110.0001 10.000 0.0001 - 100 000 11200 14251 H425 14251 1250 14250 14251 14251 1425) 14251 125 1425) 5100 (1213001 12.050 -1 304.750 132.000 132.000 132.000 103.399 1435491 1514641 0122.01 T722001 1039117 70.62 1643 340 (1.130.5 115134211405301 -10.679.432 15.000 15.000 t500m 115.00 5.000 16.000 15 000 115.0001 15.000 1150001 16.000 115.000-180.000 1046 143.350 410320 135.2001 1200 08.000 David The is rout 2; Bomoved the month Peped the month Torinong Addback mache Cashbanding (203.0001 92.0001 5.000 4747 12.000 1920001 2000 200.00 120001 23.000 5.000 F 700 72 73912674 120.00 102 000 75 000 1522 102 0001 2000 2.0001 112.000 15 000 157.199 377 120001 2.000 102001 12 000 1.000 1972 MOTE 1102001 12000 020001 me on T1000 15.000 522209-1085 221 102.00 - 12.000 19200 - 1224.000 15.000. 100 000 89822 163906 DM N Cash Oisb DE MOH COM A COGS SAA XD Cash Budget Projede Prod's Celds 125 nota de Ken Sulley O Bomoved this month Repaid month Totallinancing d back inimum cash bace Cashbalance, ending 2.000 20001 15.000 + 457 487 D E H 12.000 102 0001 1902.000 (102 0001 12.000 1102 0001 702 0001 12 000 1102.000 2.0001 2000 102.0001 1102 000 1102.0001 1902.0000 102 000 15 000 15.000 15.000 15 000 15.000 15 000 15.000 15 000 782386 3536332 - 67954 + 135350 57.188 317.05 - 197,326 - 36075 M N 1 102.0001 1702 0000 2000 - 1224 000 1102 0001 112.00 1020001 - 1224 000 15 000 15 000 T5.000 100.000 522.209 41055 221 895352 + 1639566 Bank loan balance stend of month Lo balance for were calcin 102 000 102.000 102.000 102.000 102.000 102.000 102.000 102.000 102.000 102.000 12.000 102.000 Altec Manufacturing Inc. Schedule of income Taxes Payable For the year ended December 31, 2022 11 200 Taiset ouing beging you Add neone tell they w Dedopamente during the po balance oving at begin natalents ) Towing wend of you Tiran Maryann 0 000.00 (112001 100 0001 720001 Prodin DM & Cash Disb DL MOH COGM & COGS 58A Exp Cash Budget Projede. D B 1 Altec Manufacturing Inc. 2 Budgeted Income Statement 3 For the year ended December 31, 2022 4 5 Sales $ 12.000.000 6 Cost of goods sold 8581944 7 Gross Margin $ 3.418.056 8 Selling & administrative expenses 2.600.059 9 Net operating income $ 817.997 10 Interest expense (5.100) 11 Net income before taxes 823.097 12 Income tax expense (120.000) 13 Net Income $ 943.097 14 15 Altec Manufacturing Inc. 16 Budgeted Statement of Retained Earnings 17 For the year ended December 31, 2022 18 19 Retained earnings beginning of year $ 1.499.015 20 Net Income $ 943.097 21 Sub-total 2.442. 112 - DL MOH COGM & COGS S&A exp Cash Budget Projected Financial Statements $ $ B D 16 Budgeted Statement of Retained Earnings 17 For the year ended December 31, 2022 18 19 Retained earnings beginning of year 1.499.015 20 Net Income $ 943.097 21 Sub-total $ 2.442.112 22 Dividends declared $ 128.000 23 Retained earnings end of year $ 2.314.112 24 25 Altec Manufacturing Inc. 26 Budgeted Balance Sheet 27 as at December 31, 20x2 28 29 Assets 30 Cash $ (1.639.566) 31 Accounts Receivable 2.385.600 32 Inventory. Raw Materials 1.395.102 33 Inventory: Finished goods 150.726 34 Prepaid Insurance 277.920 35 Capital assets (net) (304.750) 36 Total Assets 2.265.032 DL MOH COGM & COGS Cash Budget Projected Financial Statements S&A exp 277.920 (304.750) 2.265.032 268342,382 -5100 - 120000 143.242 B 34 Prepaid Insurance 35 Capital assets (net) 36 Total Assets 37 Liabilities and Shareholders' Equity 38 Liabilities 39 Bank Loan Payable 40 Accounts payable 41 Interest payable 42 Income taxes payable 43 Total Liabilities 44 Shareholders' Equity 45 Capital stock 46 Retained earnings 47 Total Shareholders' equity 48 Total Liabilities & Shareholders' Equity 49 50 51 52 MOH COGM & COGS Cash Budget 2.314.112 143.242 $ 2.121.790 DL S&A exp Projected Financial Statements + Bleta

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Basics

Authors: 3G E-Learning

1st Edition

1984624261, 978-1984624260

More Books

Students also viewed these Accounting questions