need help with RNF asap
o P Pro Forma Income Statement 4 $ $ $ 5 $ $ $ $ June 30, 2021 125,000.00 78.400.00 46 600.00 15,000.00 31,600.00 2,000.00 29.600.00 5,920 00 23.680.00 $ 5 Sales Revenue 6 Cost of Goods Sold 7 Gross Profit 8 Selling, general and administrative expense 9 Operating profit 10 Interest expense 11 Eamings before taxes (ERT) 12 Taxes (2096) 13 Earnings after taxes 14 15 Change in Retained Earnings 16 Common stock dividends declared 17 Increase in retained earrings 18 19 20 Answer B(in) 21 Assumptions 22 Assume 12% of sales are administrative expenses Assume that there is interest expense of S2000 24 Taxes should be 20% of EBT (Eaming before taxes) 25 Add $2000 of Common stock dividends declared 2,000.00 21,680.00 5 25 Total production costs Kitchen Foils 1550 $ 16.00 $ 24800 Water Bottles 2550 2200 56100 80900 Table 1.6 Allocation of manufacturing cost and determination of gross profits Kitchen Foils Water bottles Combined 47 4 49 Units to be produced (Table 1-3) 50 Cost per unit (Table 1-4) 51 Total Cost 52 Total 53 54 55 56 57 58 Table 1 59 Quantity Sold 60 Sales Price 61 Sales Revenne 62 63 Costs of goods sold 64 Table 1-2 65 Old Inventory 66 Quantity 67 Cost per unit 68 Total 69 70 Table 1-4 (Remainder) 71 New Inventory $ $ 1500 25.00 $ 37,500.00 $ 2500 35.00 87,500.00 $ 125,000.00 $ $ 100 14.00 $ 1,400.00 $ 200 20.00 4,000.00 $ 5,400.00 H 1 K M N o P $ 5 71 New Caventory 72 Quantity 73 Cost per unit 74 Total 75 76 Total cost of goods sold 77 78 Gross Profit 79 1400 1600$ 22,100.00 $ 2300 22.00 50,500.00 $ 73.000.00 $ 23,800.00 $ 54,600 005 78.400.00 $ 13,700.00 S 32 900 00 5 46,000.00 31 New Inventory (Quantity) - 1400 and 2300 (because of remaining inventory after selling old inventory first for completing target of sales) Table 1-7 Value of ending bentary 313 M es 36 Beginning Inventory (Table 1-2) 27 Total Production Cost (Table 1-5) 78 Total Inventory Available for Sale 9 Cost of Goods sod (Table 1-6 20 Ending Awtory 91 Add $ $ $ $ $ 5,400.00 80 900 00 86,300.00 28.400.00 7,900.00 Minus 1 2 May June $ Table 1-15 Cash Budget With Borrowing and Repayment Provisions January February March April 2,1925 8,4833 5,193 $ 5.2675 6000 $ 8,1925 6,000 $ 6.000 $ 8,192 2915 807 s 11,267 s 5 6.2915 6,807S 5,267 $ 6.291 $ 13.098 $ 7831 4 Net Cash Flow (Table 1-14) 5 Beginning Cash Balance 6 Cumulative Cash Balance 7 Monthly Loan (or Repayment) a Cumulative Low Balance 10913 10.936 $ 12,7675 6,000 18,767 97831 $ $ 6,007 6,007 6,000 $ 6,000$ 10,936S 6.000 10 Ending Cash Balance $ 8,1925 6.000 $ 11 12 Assume that atleast 56000 should be required as minimum ending inventory 14 Assume the beginning cash balance for month January is 56000 15 16 17 Tale 19 Monthly Saint Peder March April 16750,00 11,250,095 May 1R 25000 June 25,000.00 2 3 January February 45 1R750.00 12.500.00 5 6 7 A 9 10 Sales 11 Collections: 20% of current sales 12 Collections: 80% of previous month sales 13 Total Cash Recipes 14 Table 1.10 Month Cash Recipes December January February March Apr My $ 15,000 $18.750 5 12.500 518,750 $ 31,250 5 18,750 $25.000 $ 3.7505 2,500 $3,750 $ 6,250 $ 3.750 $5,000 $ 12,000 5 15.000 $10,000 $15,000 $25 000 $ 15,000 $15750 517 500 13.250 $ 21,250 $ 28,750 $ 20.000 35 16 17 13 19 20 Materials 21 Labour 22 Overhead 21 24 25 Tolle III Component Cous of Manufactured Goods Kitchen Fails Water Bones Units Produced Cost per unit Total cost Cimits Produced Cost perint Total Cost 1550 $ 9.00 $ 13.950 2550 $ 12.00 5 1550 $ 400 6,200 2550 $ 600 $ 1550 $ 3.00 $ 4650 2550 $ 4.00 $ Combined Cour 30,600 4550 15,300 $ 21,500 10.2005 14.850 Supporting Schedules 500 Table 112 Cash Budget BV Supporting Schedule Biv) Pro Forma Balance Sh 25 Table 1 12 26 Average Monthly Manufacturing Costs 27 Total Costs Time Frame Average Monthly Cost 28 Materials (Table 1-11) $ 44,550 6 months 7.425 29 Labour (Table 1-11) 21.500 6 months 3,583 30 Overhead (Table 1-111 $ 14,850 6 months 2425 31 32 Table 1-13 34 Summary of all monthly cash pay 35 December January February March Aprw Mary 36 Monthly material purchase (Table 1-12) $ 5,000 $ 7,425 $ 7,425 $ 7,425 5 7.425 $ 7425 $ 7,425 37 Payment of material (pror months purchase) $5,000 $ 7.4257,425$ 7,425 S 7425 $ 7,425 38 Monthly labour cost (Table 1.12) $ 3,583 $3,583$ 3,583$ 3,583 $ 3,583 $ 3,583 39 Monthly overhead (Table 1-12) $ 2.475 52.475 5 2,475$ 2,475 $ 2,475 $2,475 40 Selling, general and administrative expense (Table 1-8) per month $ 2.500 $ 2.500 $ 2.500 S 2,500 $ 2.500 $ 2,500 41 Interest Expense (Table 1-8) $ 2,000 42 Taxes (Two equal payments) (Table 1-8) 5 2.900 $ 2,960 43 Cash Dividend $ 2,000 44 New Equipment Purchases $10,000 8000 45 46 Total Cash Payment 513.558525983 518,0435 15,983 $15.983 5 30.943 47 49 50 Table 114 51 Monthly Car Now 52 January February March April May June 53 Total Cash Receipts (Table 1-10) $15.750 $ 17.00 $13,750 $21,250 $28,750 $ 20,000 54 Total Cash Payments (Table 1-13) $ 13,558 $25,983 $18,943 $ 15,983 $15.983 5 30.043 55 56 Ner Cash Flow $ 2.1923 883 $ 5103 $ 5,267 $12,767510943 57 50 9 Net Cash FlowTotal Cash Receipts Total Cash Payments 0 61 BAND Wesampions 63 Assume monthly sales (Table 1.9) for Tan Feb March April May and one are 15%, 104, 159259, 15% and 20% of total sales respectively 64 Assume that sales (Table 1-10) for December month is $15000 65 Formula for Average Monthly Cost (Table 1-12)- Total Costs/6. 66 Monthly material purchase (Table 1-13) is $5000 for December 07 68 09 Kahrr Manufacturing 2 Pre Forma Balance Sheet (ASPE) 1 2021 5 Aten 5 CITAN Ca (Table 1-15) $ 6.000 Acer Receivable (Table 1-10) $ 20.000 Inventory (Take 1:7) $ 7.900 Tanel Current Arsen S 39.900 Plant and Equment S 54.600 Tout Ann $ 88,500 Line and Shareholders Accounts Payable (Table 1-13) $ 7,425 Nota Payable 1 3,295 Loo am Gebit (Previous Yalance Sheet) $ 18,500 12 Common Stock (Previese Balance Sheet) 1 13,500 Ratandang $ 45.789 1 Total Labin and Shareholders $ $3.500 30 ! 12 M planen for Polerme Helene Sheet 2 Plant and Equipment Previou Blane haut (Plant and New Equment Pham (11316600 3000 34600 Kated Earnings Previoun Balance Sheet Retained Earning) + Pra Forma Income Statement les in Retained Barne-2410021680 - 45710 30 22 Dec 31, 2020 1 Kahrr Manufacturing 2 Bolnce Sheet 3 4 5 CA 6 Cash 7 Accounts Rivable Inventory 3 Total Curen 10 Plant and Equipment 11 Total 12 Liabilite and Shareholders Equity 10 Accounts Payable 15 Long-term debt 16 Common Stock 17 Rain Farnings 10 Toul Line and Shareholder's Equity 5 5 $ $ $ $ 6.000 13.000 6.500 25300 36.600 62.100 6.000 $ 5 5 3 5 18.500 13.500 24,100 6.100 20 21 24 25 Dec 31, 2020 1 Kahrr Manufacturing 2 Bolnce Sheet 3 4 5 CA 6 Cash 7 Accounts Rivable Inventory 3 Total Curen 10 Plant and Equipment 11 Total 12 Liabilite and Shareholders Equity 10 Accounts Payable 15 Long-term debt 16 Common Stock 17 Rain Farnings 10 Toul Line and Shareholder's Equity 5 5 $ $ $ $ 6.000 13.000 6.500 25300 36.600 62.100 6.000 $ 5 5 3 5 18.500 13.500 24,100 6.100 20 21 24 25 Kar Mercury Po Farm and EXPED Curreras Saat M Dede AN Ae Arsene 1 MA WARPER Cain AUFT In 1 TREP Ferar 1 11 7 740 1400 1 2300 50 11 AW Notes Long Town Como Previour the ed Emi Vevares Pares 21 23 Arun there was 2014 fe 1 o P Pro Forma Income Statement 4 $ $ $ 5 $ $ $ $ June 30, 2021 125,000.00 78.400.00 46 600.00 15,000.00 31,600.00 2,000.00 29.600.00 5,920 00 23.680.00 $ 5 Sales Revenue 6 Cost of Goods Sold 7 Gross Profit 8 Selling, general and administrative expense 9 Operating profit 10 Interest expense 11 Eamings before taxes (ERT) 12 Taxes (2096) 13 Earnings after taxes 14 15 Change in Retained Earnings 16 Common stock dividends declared 17 Increase in retained earrings 18 19 20 Answer B(in) 21 Assumptions 22 Assume 12% of sales are administrative expenses Assume that there is interest expense of S2000 24 Taxes should be 20% of EBT (Eaming before taxes) 25 Add $2000 of Common stock dividends declared 2,000.00 21,680.00 5 25 Total production costs Kitchen Foils 1550 $ 16.00 $ 24800 Water Bottles 2550 2200 56100 80900 Table 1.6 Allocation of manufacturing cost and determination of gross profits Kitchen Foils Water bottles Combined 47 4 49 Units to be produced (Table 1-3) 50 Cost per unit (Table 1-4) 51 Total Cost 52 Total 53 54 55 56 57 58 Table 1 59 Quantity Sold 60 Sales Price 61 Sales Revenne 62 63 Costs of goods sold 64 Table 1-2 65 Old Inventory 66 Quantity 67 Cost per unit 68 Total 69 70 Table 1-4 (Remainder) 71 New Inventory $ $ 1500 25.00 $ 37,500.00 $ 2500 35.00 87,500.00 $ 125,000.00 $ $ 100 14.00 $ 1,400.00 $ 200 20.00 4,000.00 $ 5,400.00 H 1 K M N o P $ 5 71 New Caventory 72 Quantity 73 Cost per unit 74 Total 75 76 Total cost of goods sold 77 78 Gross Profit 79 1400 1600$ 22,100.00 $ 2300 22.00 50,500.00 $ 73.000.00 $ 23,800.00 $ 54,600 005 78.400.00 $ 13,700.00 S 32 900 00 5 46,000.00 31 New Inventory (Quantity) - 1400 and 2300 (because of remaining inventory after selling old inventory first for completing target of sales) Table 1-7 Value of ending bentary 313 M es 36 Beginning Inventory (Table 1-2) 27 Total Production Cost (Table 1-5) 78 Total Inventory Available for Sale 9 Cost of Goods sod (Table 1-6 20 Ending Awtory 91 Add $ $ $ $ $ 5,400.00 80 900 00 86,300.00 28.400.00 7,900.00 Minus 1 2 May June $ Table 1-15 Cash Budget With Borrowing and Repayment Provisions January February March April 2,1925 8,4833 5,193 $ 5.2675 6000 $ 8,1925 6,000 $ 6.000 $ 8,192 2915 807 s 11,267 s 5 6.2915 6,807S 5,267 $ 6.291 $ 13.098 $ 7831 4 Net Cash Flow (Table 1-14) 5 Beginning Cash Balance 6 Cumulative Cash Balance 7 Monthly Loan (or Repayment) a Cumulative Low Balance 10913 10.936 $ 12,7675 6,000 18,767 97831 $ $ 6,007 6,007 6,000 $ 6,000$ 10,936S 6.000 10 Ending Cash Balance $ 8,1925 6.000 $ 11 12 Assume that atleast 56000 should be required as minimum ending inventory 14 Assume the beginning cash balance for month January is 56000 15 16 17 Tale 19 Monthly Saint Peder March April 16750,00 11,250,095 May 1R 25000 June 25,000.00 2 3 January February 45 1R750.00 12.500.00 5 6 7 A 9 10 Sales 11 Collections: 20% of current sales 12 Collections: 80% of previous month sales 13 Total Cash Recipes 14 Table 1.10 Month Cash Recipes December January February March Apr My $ 15,000 $18.750 5 12.500 518,750 $ 31,250 5 18,750 $25.000 $ 3.7505 2,500 $3,750 $ 6,250 $ 3.750 $5,000 $ 12,000 5 15.000 $10,000 $15,000 $25 000 $ 15,000 $15750 517 500 13.250 $ 21,250 $ 28,750 $ 20.000 35 16 17 13 19 20 Materials 21 Labour 22 Overhead 21 24 25 Tolle III Component Cous of Manufactured Goods Kitchen Fails Water Bones Units Produced Cost per unit Total cost Cimits Produced Cost perint Total Cost 1550 $ 9.00 $ 13.950 2550 $ 12.00 5 1550 $ 400 6,200 2550 $ 600 $ 1550 $ 3.00 $ 4650 2550 $ 4.00 $ Combined Cour 30,600 4550 15,300 $ 21,500 10.2005 14.850 Supporting Schedules 500 Table 112 Cash Budget BV Supporting Schedule Biv) Pro Forma Balance Sh 25 Table 1 12 26 Average Monthly Manufacturing Costs 27 Total Costs Time Frame Average Monthly Cost 28 Materials (Table 1-11) $ 44,550 6 months 7.425 29 Labour (Table 1-11) 21.500 6 months 3,583 30 Overhead (Table 1-111 $ 14,850 6 months 2425 31 32 Table 1-13 34 Summary of all monthly cash pay 35 December January February March Aprw Mary 36 Monthly material purchase (Table 1-12) $ 5,000 $ 7,425 $ 7,425 $ 7,425 5 7.425 $ 7425 $ 7,425 37 Payment of material (pror months purchase) $5,000 $ 7.4257,425$ 7,425 S 7425 $ 7,425 38 Monthly labour cost (Table 1.12) $ 3,583 $3,583$ 3,583$ 3,583 $ 3,583 $ 3,583 39 Monthly overhead (Table 1-12) $ 2.475 52.475 5 2,475$ 2,475 $ 2,475 $2,475 40 Selling, general and administrative expense (Table 1-8) per month $ 2.500 $ 2.500 $ 2.500 S 2,500 $ 2.500 $ 2,500 41 Interest Expense (Table 1-8) $ 2,000 42 Taxes (Two equal payments) (Table 1-8) 5 2.900 $ 2,960 43 Cash Dividend $ 2,000 44 New Equipment Purchases $10,000 8000 45 46 Total Cash Payment 513.558525983 518,0435 15,983 $15.983 5 30.943 47 49 50 Table 114 51 Monthly Car Now 52 January February March April May June 53 Total Cash Receipts (Table 1-10) $15.750 $ 17.00 $13,750 $21,250 $28,750 $ 20,000 54 Total Cash Payments (Table 1-13) $ 13,558 $25,983 $18,943 $ 15,983 $15.983 5 30.043 55 56 Ner Cash Flow $ 2.1923 883 $ 5103 $ 5,267 $12,767510943 57 50 9 Net Cash FlowTotal Cash Receipts Total Cash Payments 0 61 BAND Wesampions 63 Assume monthly sales (Table 1.9) for Tan Feb March April May and one are 15%, 104, 159259, 15% and 20% of total sales respectively 64 Assume that sales (Table 1-10) for December month is $15000 65 Formula for Average Monthly Cost (Table 1-12)- Total Costs/6. 66 Monthly material purchase (Table 1-13) is $5000 for December 07 68 09 Kahrr Manufacturing 2 Pre Forma Balance Sheet (ASPE) 1 2021 5 Aten 5 CITAN Ca (Table 1-15) $ 6.000 Acer Receivable (Table 1-10) $ 20.000 Inventory (Take 1:7) $ 7.900 Tanel Current Arsen S 39.900 Plant and Equment S 54.600 Tout Ann $ 88,500 Line and Shareholders Accounts Payable (Table 1-13) $ 7,425 Nota Payable 1 3,295 Loo am Gebit (Previous Yalance Sheet) $ 18,500 12 Common Stock (Previese Balance Sheet) 1 13,500 Ratandang $ 45.789 1 Total Labin and Shareholders $ $3.500 30 ! 12 M planen for Polerme Helene Sheet 2 Plant and Equipment Previou Blane haut (Plant and New Equment Pham (11316600 3000 34600 Kated Earnings Previoun Balance Sheet Retained Earning) + Pra Forma Income Statement les in Retained Barne-2410021680 - 45710 30 22 Dec 31, 2020 1 Kahrr Manufacturing 2 Bolnce Sheet 3 4 5 CA 6 Cash 7 Accounts Rivable Inventory 3 Total Curen 10 Plant and Equipment 11 Total 12 Liabilite and Shareholders Equity 10 Accounts Payable 15 Long-term debt 16 Common Stock 17 Rain Farnings 10 Toul Line and Shareholder's Equity 5 5 $ $ $ $ 6.000 13.000 6.500 25300 36.600 62.100 6.000 $ 5 5 3 5 18.500 13.500 24,100 6.100 20 21 24 25 Dec 31, 2020 1 Kahrr Manufacturing 2 Bolnce Sheet 3 4 5 CA 6 Cash 7 Accounts Rivable Inventory 3 Total Curen 10 Plant and Equipment 11 Total 12 Liabilite and Shareholders Equity 10 Accounts Payable 15 Long-term debt 16 Common Stock 17 Rain Farnings 10 Toul Line and Shareholder's Equity 5 5 $ $ $ $ 6.000 13.000 6.500 25300 36.600 62.100 6.000 $ 5 5 3 5 18.500 13.500 24,100 6.100 20 21 24 25 Kar Mercury Po Farm and EXPED Curreras Saat M Dede AN Ae Arsene 1 MA WARPER Cain AUFT In 1 TREP Ferar 1 11 7 740 1400 1 2300 50 11 AW Notes Long Town Como Previour the ed Emi Vevares Pares 21 23 Arun there was 2014 fe 1