Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

someone help me with my homework? The instructions for the first part are in A, and the instructions for the second part are prepare cash

image text in transcribed

image text in transcribed

someone help me with my homework?

The instructions for the first part are in A, and the instructions for the second part are prepare cash budget for October, November, December

I. Pro Forma Statements Problem: Sheckles, Inc. A) 1. Income Statement Year Ended 2019 Balance Sheet 12/31/19 Sales Cost of Goods Sold Gross Profit Expenses Earnings Before Tax Tax (.5) Net Income $27,000 18,900 8,100 6,000 2,100 1,050 $ 1,050 Cash Accounts Receivable Inventory Gross Fixed Assets Accumulated Depreciation Net Fixed Assets Total Assets $ 500 4,500 3,150 54,000 21,600 32,400 $40.550 Accounts Payable Notes Payable Accrued Tax Common Stock Retained Earnings Total Debt & Equity $1,575 19,175 263 15,787 3.750 S40.550 A. Based on the 2019 Financial Statements above, compute Pro Forma's for 2020 using the percent of sales method using the following assumptions: a. 20% growth rate in sales, b. 15% dividend payout c. Tax rate remains at 50% 5 Prepare Cash Budget for October, November, December 2020 A.) Follow the following to prepare the budget: 1. Real Sales 2020: August - $100,000 September - $200,000 Projected for 2020: October November December - $400,000 - $300,000 - $200,000 Sales Payment History: 20% cash 50% Accts. Rec. - collected n/30 days 30% Accts. Rec. - collected n/60 days Bad Debt Expense - negligible Other Receipts: Dividend due the firm - $30,000 in December 2020. Purchases: 70% of Sales - same month of exp. Sale 10% Paid Cash 70% Paid 30 Days 20% Paid 60 Days Interest Payment: November $130,000 Dividend Payments: October = $20,000 Rent: $5,000/month Wages: 10% Sales + $8,000 Fixed Cost Taxes: $25,000 in December for 2020 Capital Investments: $10,000 in December Sinking Fund: $20,000 due December Repurchase or Retirement of Stock - None Anticipated 3. Cash Balances: @ 9/30 = $50,000; must maintain $25,000 Cash Balance Minimum (US) I. Pro Forma Statements Problem: Sheckles, Inc. A) 1. Income Statement Year Ended 2019 Balance Sheet 12/31/19 Sales Cost of Goods Sold Gross Profit Expenses Earnings Before Tax Tax (.5) Net Income $27,000 18,900 8,100 6,000 2,100 1,050 $ 1,050 Cash Accounts Receivable Inventory Gross Fixed Assets Accumulated Depreciation Net Fixed Assets Total Assets $ 500 4,500 3,150 54,000 21,600 32,400 $40.550 Accounts Payable Notes Payable Accrued Tax Common Stock Retained Earnings Total Debt & Equity $1,575 19,175 263 15,787 3.750 S40.550 A. Based on the 2019 Financial Statements above, compute Pro Forma's for 2020 using the percent of sales method using the following assumptions: a. 20% growth rate in sales, b. 15% dividend payout c. Tax rate remains at 50% 5 Prepare Cash Budget for October, November, December 2020 A.) Follow the following to prepare the budget: 1. Real Sales 2020: August - $100,000 September - $200,000 Projected for 2020: October November December - $400,000 - $300,000 - $200,000 Sales Payment History: 20% cash 50% Accts. Rec. - collected n/30 days 30% Accts. Rec. - collected n/60 days Bad Debt Expense - negligible Other Receipts: Dividend due the firm - $30,000 in December 2020. Purchases: 70% of Sales - same month of exp. Sale 10% Paid Cash 70% Paid 30 Days 20% Paid 60 Days Interest Payment: November $130,000 Dividend Payments: October = $20,000 Rent: $5,000/month Wages: 10% Sales + $8,000 Fixed Cost Taxes: $25,000 in December for 2020 Capital Investments: $10,000 in December Sinking Fund: $20,000 due December Repurchase or Retirement of Stock - None Anticipated 3. Cash Balances: @ 9/30 = $50,000; must maintain $25,000 Cash Balance Minimum (US)

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_2

Step: 3

blur-text-image_3

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

The Internet Supply Chain Impact On Accounting And Logistics

Authors: D. Chorafas

5th Edition

0333949633, 9780333949634

More Books

Students also viewed these Accounting questions