Question

Complete the following Income Statement for 12/31/2019 with these assumptions which are in no particular order:...

Complete the following Income Statement for 12/31/2019 with these assumptions which are in no particular order:

  1. The company has an Operating Profit Margin of 30%
  2. The company has an Account Receivable turnover of 12
  3. The Contribution Rate for this company is 40%
  4. They have an Interest Coverage ratio of 5
  5. All sales for the company were on credit
  6. They have a 30% tax rate
  7. The account receivable balance as of 12/31/2019 was $7,000,000
Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Solution:-

Income statement for 12/31/2019

Particulars Amount
Sales $84,000,000
-Variable costs ($50,400,000)
Contribution $ 33,600,000
-Fixed costs ($8,400,000)
EBIT $25,200,000
-Interest ($5,040,000)
EBT $20,160,000
-Tax (EBT * tax rate) ($6,048,000)
Net Income $14,112,000

Working notes:

1.Sales = Accounts receivable * Turnover ratio

= $7,000,000 * 12

= $84,000,000

2.Variable cost = Sales * (1-contribution rate)

= $84,000,000 * (1-40%)

= $84,000,000 * 60%

= $50,400,000

3.Fixed costs = Sales * (1-operating profit) - Variable costs

= $84,000,000 * (1-30%) - $50,400,000

= $84,000,000 * 70% - $50,400,000

= $58,800,000 - $50,400,000

= $8,400,000

4.Interest = Sales * operating profit / interest coverage ratio

= $84,000,000 * 30% / 5

= $5,040,000

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Complete the following Income Statement for 12/31/2019 with these assumptions which are in no particular order:...
Complete the following Income Statement for 12/31/2019 with these assumptions which are in no particular order: HINT: Determine revenue as a starting point. If you cannot figure that out put in a number and finish based on rest of the assumptions as this will allow you to receive some points. 1. The company has an Operating Profit Margin of 30% 2. The company has an Account Receivable turnover of 10 3. The Contribution Rate for this company is 40% 4....
Arlington Merchants reported the following on its income statement for the fiscal years ended December 31,...
Arlington Merchants reported the following on its income statement for the fiscal years ended December 31, 2020 and 2019. 2020 2019 Sales $4,853,000 $4,753,000 Cost of goods sold 3,266,069 3,203,522 Gross profit 1,586,931 1,549,478 Operating expenses 878,393 893,564 Profit $708,538 $655,914 Calculate the gross profit margin for Arlington for 2019 and 2020. (Round answers to 1 decimal place, e.g. 52.7%.) Gross profit margin 2020 % 2019 % eTextbook and Media       Calculate the profit margin for Arlington for 2019...
The balance sheet and income statement for the A. Thiel Mfg. Company are as follows: Balance...
The balance sheet and income statement for the A. Thiel Mfg. Company are as follows: Balance Sheet ($000) Cash $ 500 Accounts receivable 2,000 Inventories 1,000 Current assets $3,500 Net fixed assets 4,500 Total assets $8,000 Accounts payable $1,100 Accrued expenses 600 Short-term notes payable 300 Current liabilities $2,000 Long-term debt 2,000 Owners’ equity 4,000 Total liabilities and owners’ equity $8,000 Income Statement ($000) Sales (all credit) $8,000 Cost of goods sold (3,300) Gross profit $4,700 Operating expenses (includes $500...
Accounting for Receivables Solve the Following Problems At December 31, 2019, Carl’s Toys had a balance...
Accounting for Receivables Solve the Following Problems At December 31, 2019, Carl’s Toys had a balance of $248,100 in its Accounts Receivable account and a credit balance of $900 in its Allowance for Doubtful Accounts account. Carl’s Toys analyzed and aged its accounts receivable based on the following estimated uncollectible amounts: Age of Accounts Receivables Balance Estimated % Uncollectible Current $ 130,500 0.6% 31 to 60 day 66,300 2.0% 61 to 90 days 26,700 5.5% Over 91 days    24,600...
Lincoln uses income statement approach to estimate uncollectible accounts. During the year of 2019, total sales...
Lincoln uses income statement approach to estimate uncollectible accounts. During the year of 2019, total sales amount to $400,000 of which 37.5% is cash sales. Past experience indicate that 1.5% of credit sales are probable to be uncollectible. Prior to adjustment, the allowance for doubtful accounts has a credit balance of $1,500 at December 31, 2019. Total amount of accounts receivable, on the other hand, amount to $267,000 as of December 31, 2019. Instructions (25 points): Compute the uncollectible accounts...
1) Berkshire LLC reported the following income statement and balance sheet amounts on December 31, 2011....
1) Berkshire LLC reported the following income statement and balance sheet amounts on December 31, 2011. 2011 2010 Net sales revenue (all credit) $950,000 Cost of goods sold 630,000 Gross profit 320,000 Selling and general expenses 230,000 Interest expense    20,000 Net income $70,000 Current assets $60,000 $55,000 Long-term assets    465,000    445,000 Total assets - 12/31 $525,000 $500,000 Current liabilities $25,000 $20,000 Long-term liabilities 105,000 205,000 Common stockholders’ equity - 12/31    395,000    275,000 Total liabilities and...
Income Statement For the year ended December​ 31, 2019 Sales Revenue ​$347,000 Cost of Goods Sold...
Income Statement For the year ended December​ 31, 2019 Sales Revenue ​$347,000 Cost of Goods Sold ​(78,000) Gross Profit ​$269,000 Selling and Administrative Expenses ​(43,900) Operating Income ​225,100 Gain on Sale of Equipment ​5,500 Net Income ​$230,600 All of the​ company’s sales are made on account. At the beginning of the​ year, the Accounts Receivable balance was​ $53,500. The balance had decreased to​ $50,200 by​ year-end. All of the​ company’s inventory purchases are made on account. Accounts Payable consists solely...
Lincoln uses income statement approach to estimate uncollectible accounts. During the year of 2019, total sales...
Lincoln uses income statement approach to estimate uncollectible accounts. During the year of 2019, total sales amount to $400,000 of which 37.5% is cash sales. Past experience indicate that 1.5% of credit sales are probable to be uncollectible. Prior to adjustment, the allowance for doubtful accounts has a credit balance of $1,500 at December 31, 2019. Total amount of accounts receivable, on the other hand, amount to $267,000 as of December 31, 2019. Instructions (25 points): a. Compute the uncollectible...
Choose a company from your own and complete this statement. Please provide the company's name and...
Choose a company from your own and complete this statement. Please provide the company's name and the link. ______________________ (Company Name) Financial Statement Assessment Income Statement 2019 2018 Change Sales Gross Profit    G&A       Net Income    Gross Profit Percentage Return on Sales Balance Sheet Cash and Equivalents Inventory Accounts Receivable Debt Other Liabilities Current Ratio Quick Ratio Debt to Equity Ratio
The interest accrued to 31 December 2019 on notes receivable is composed of the following: Platteville...
The interest accrued to 31 December 2019 on notes receivable is composed of the following: Platteville Plumbers, 12%, 6 months, due March 31, 2020 $1,350 Bilder Construction, 14%, 6 months, due June 14,2020 295 Beverly’s Building, 12%, 6 months, due June 26, 2020 23 Total $1,668 Note that the balance in notes receivable account of $45,000 that appeared on the trial balance on November 30, 2019 is a note receivable from Platteville Plumbers. prepare adjusting entry as on 31 dec...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT