Question

1 Approved Answer

Posted on Sep 20, 2024

1) Prepare a Proforma Income statement 2) Prepare a purchases budget D E B 1 Bobcat Beverage Company 2 Balance Sheets 3 As of 4

1) Prepare a Proforma Income statement

2) Prepare a purchases budget image text in transcribed

D E B 1 Bobcat Beverage Company 2 Balance Sheets 3 As of 4 August 31, 2019 5 ASSETS 6 CURRENT ASSETS 7 Cash 25,800 8 Accounts Receivable $ 595,000 9 Inventory $ 50,688 10 Prepaid Insurance $ 27,500 11 TOTAL CURRENT ASSETS $ 698,988 12 13 PROPERTY PLANT & EQUIPMENT 14 Land $ 100,000 15 Equipment 300,000 16 Accumulated Depreciation $ (100,000) 17 TOTAL PPE $ 300,000 18 19 TOTAL ASSETS $ 998,988 20 21 22 LIABILITIES & STOCKHOLDERS EQUITY 23 CURRENT LIABILITIES 24 Accounts Payable $ 81,859 05 Commissions Payable $ 59,500 26 Advertising Expense Payable $ 121,250 27 Income Taxes Payable $ 22,000 28 Dividends Payable $ 29 TOTAL CURRENT LIABILITIES $ 284,609 30 31 LONG TERM DEBT $ 220,000 32 33 STOCKHOLDERS EQUITY 34 Common Stock $ 35 Retained Earnings 89,500 $ 404,879 36 TOTAL STOCKHOLDERS EQUITY $ 494,379 37 38 TOTAL LIABILITIES & STOCKHOLDERS EQUITY $ 998,988 39 40 41 12 43 44 ih % Conditioning S Font Alignment Number Cells Editing Paste Analyse Sant . Clipboard Styles Analysis Sentity 1 D September 5700,000 October $800,000 November $900.000 245 76% 30 78% 22 Expected sales tall sales are credit ales) + Collections of Accounts Receivable 1 Month of Sale 7 Month following Sale 8 Cost of Goods Sold percentage of sales 30 1 Inventory Purchase information #2 Purchases paid in current month 33 Purchases paid innan month 4 Purchases are all on credit 15 Planned ending inventory as a percentage of next month's Cost of Goods Sold 17 Sales Commission Information 10 Sales commissions as a percentage of sales 29 Sales commissions are paid the month after they are incurred 20 1 Advertising Expense Information 22 Variable Rate 23 Fored Cost 24 25 20 Insurance policy Information 21 of months of insurance coverage paid for each year 28 The powcy period is from August 1 to July 31 each year 29 The premium was pard on July 31, 2019 10 There will be charged to prepaid insurance 6.5 17 50% 560.000 12 $30,000 500,000 15.00% 32 General and Administrative pense Information 33 Fad cont portion > Varublurate as a percentage of sales) 36 Selling and administrative expenses are paid in the months incurred 37 Asset information 38 Purchase and on September 15, 2019 30 Current Depreciation expense per month 40 41 Long-Term Loan interest Information The interest on the long-term debit per month is 43 Interest is paid on the principle balance at the beginning of the month 44 Minian Cash Bance 46 New borrowing must be in $1.000 increments 150,000 10,000 15 $25.000 47 Texnormation 4 Income tax rate 50 5 bindendedamaian Cash didend declared on September 20, 2019 51 Cash videre pad on October 15, 2019 14 56 30 SY 335.000 D E B 1 Bobcat Beverage Company 2 Balance Sheets 3 As of 4 August 31, 2019 5 ASSETS 6 CURRENT ASSETS 7 Cash 25,800 8 Accounts Receivable $ 595,000 9 Inventory $ 50,688 10 Prepaid Insurance $ 27,500 11 TOTAL CURRENT ASSETS $ 698,988 12 13 PROPERTY PLANT & EQUIPMENT 14 Land $ 100,000 15 Equipment 300,000 16 Accumulated Depreciation $ (100,000) 17 TOTAL PPE $ 300,000 18 19 TOTAL ASSETS $ 998,988 20 21 22 LIABILITIES & STOCKHOLDERS EQUITY 23 CURRENT LIABILITIES 24 Accounts Payable $ 81,859 05 Commissions Payable $ 59,500 26 Advertising Expense Payable $ 121,250 27 Income Taxes Payable $ 22,000 28 Dividends Payable $ 29 TOTAL CURRENT LIABILITIES $ 284,609 30 31 LONG TERM DEBT $ 220,000 32 33 STOCKHOLDERS EQUITY 34 Common Stock $ 35 Retained Earnings 89,500 $ 404,879 36 TOTAL STOCKHOLDERS EQUITY $ 494,379 37 38 TOTAL LIABILITIES & STOCKHOLDERS EQUITY $ 998,988 39 40 41 12 43 44 ih % Conditioning S Font Alignment Number Cells Editing Paste Analyse Sant . Clipboard Styles Analysis Sentity 1 D September 5700,000 October $800,000 November $900.000 245 76% 30 78% 22 Expected sales tall sales are credit ales) + Collections of Accounts Receivable 1 Month of Sale 7 Month following Sale 8 Cost of Goods Sold percentage of sales 30 1 Inventory Purchase information #2 Purchases paid in current month 33 Purchases paid innan month 4 Purchases are all on credit 15 Planned ending inventory as a percentage of next month's Cost of Goods Sold 17 Sales Commission Information 10 Sales commissions as a percentage of sales 29 Sales commissions are paid the month after they are incurred 20 1 Advertising Expense Information 22 Variable Rate 23 Fored Cost 24 25 20 Insurance policy Information 21 of months of insurance coverage paid for each year 28 The powcy period is from August 1 to July 31 each year 29 The premium was pard on July 31, 2019 10 There will be charged to prepaid insurance 6.5 17 50% 560.000 12 $30,000 500,000 15.00% 32 General and Administrative pense Information 33 Fad cont portion > Varublurate as a percentage of sales) 36 Selling and administrative expenses are paid in the months incurred 37 Asset information 38 Purchase and on September 15, 2019 30 Current Depreciation expense per month 40 41 Long-Term Loan interest Information The interest on the long-term debit per month is 43 Interest is paid on the principle balance at the beginning of the month 44 Minian Cash Bance 46 New borrowing must be in $1.000 increments 150,000 10,000 15 $25.000 47 Texnormation 4 Income tax rate 50 5 bindendedamaian Cash didend declared on September 20, 2019 51 Cash videre pad on October 15, 2019 14 56 30 SY 335.000