Question

In: Finance

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 output in a number and finish based on the 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 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

Sales      

-Fixed Costs

- Variable Costs

EBIT

- Interest

Profit before Tax

- Tax

Net Income

Solutions

Expert Solution

1. Sales = Accounts Receivable * Turnover Ratio

Sales = 7000000 * 12 = $84000000

2. Variable Costs = Sales * (1 - Contribution rate) = 84000000 * 0.60 = $50400000

3. Fixed Costs = Sales * (1 - Operating profit) - Variable Costs = 84000000 * 0.7 - 50400000 = $8400000

4. Interest = Sales * Operating profit / Interest Coverage ratio = 84000000 * 0.30 / 5 = 5040000


Related Solutions

Below are Lebnas Corp.’s 2019 income statement and comparative balance sheet at 12/31/2019 and 12/31/2018. Additional...
Below are Lebnas Corp.’s 2019 income statement and comparative balance sheet at 12/31/2019 and 12/31/2018. Additional information: On December 31, 2018, Lebnas acquired 25% of Island Co.’s common stock for $609,000. On that date, the carrying value of Island’s assets and liabilities, which approximated their fair values, was $2,435,000. Island reported income of $319,000 for the year ended December 31, 2019. No dividend income was received by Lebnas on Island’s common stock during the year 2019. During 2018, Lebnas loaned...
Below are Lebnas Corp.’s 2019 income statement and comparative balance sheet at 12/31/2019 and 12/31/2018.   Additional...
Below are Lebnas Corp.’s 2019 income statement and comparative balance sheet at 12/31/2019 and 12/31/2018.   Additional information:                                                   On December 31, 2018, Lebnas acquired 25% of Island Co.’s common stock for $609,000. On that date, thecarrying value of Island’s assets and liabilities, which approximated their fair values, was $2,435,000. Islandreported income of $319,000 for the year ended December 31, 2019. No dividend income was received by Lebnas on Island’s common stock during the year 2019. During 2018, Lebnas loaned $797,500 to...
Post the following transactions to the T-Accounts, then prepare 12/31/2006 Balance Sheet, Income Statement, Statement of...
Post the following transactions to the T-Accounts, then prepare 12/31/2006 Balance Sheet, Income Statement, Statement of Retained Earnings, and Statement of Cash Flow. 1/7/06 Collected $80,000 on Accounts Receivable 1/15/06 Sold an additional 100,000 shares at $5 per share 2/1/06 Made a sale of $90,000 on account. Cost of inventory sold was $65,000 2/15/06 Bought merchandise inventory for $70,000 cash 3/1/06 Paid vendors $16,000 cash on Accounts Payable 6/30/06 Made payment of $25,000 on Notes Payable 7/1/06 Purchased $10,000 worth...
Keisy’s Topical Kids Inc. had the following information for 2019 and 2020: Account 12/31/2020 12/31/2019 Cash...
Keisy’s Topical Kids Inc. had the following information for 2019 and 2020: Account 12/31/2020 12/31/2019 Cash and Cash Equivalents $12,000 $16,000 Short-Term Investments 11,000 5,000 Current Receivables, net 23,000 32,000 Inventory 26,000 16,000 Prepaid Insurance 2,000 3,000 Salaries Payable 17,000 28,000 Short-Term Notes Payable 12,000 16,000 Credit Sales for year 320,000 210,000 Answer the following questions: Compute the Current Ratio for 2019 and 2020. What does the results of a current ratio measure? Did the Current Ratio improve and is...
Ratio Analysis Byers Company presents the following condensed income statement for 2019 and condensed December 31,...
Ratio Analysis Byers Company presents the following condensed income statement for 2019 and condensed December 31, 2019, balance sheet: Income Statement Sales (net) $267,000 Less:      Cost of goods sold $160,000      Operating expenses 62,000      Interest expense 11,000      Income taxes 10,000      Total expenses (243,000) Net income $24,000 Balance Sheet Cash $10,000 Current liabilities $40,000 Receivables (net) 22,000 Bonds payable, 10% 110,000 Inventory 56,000 Common stock, $10 par 100,000 Long-term investments 30,000 Additional paid-in capital 95,000 Property and equipment (net) 282,000 Retained earnings...
Will a Balance Sheet Statement done quarterly as of 2019-12-31 have the same numbers as a...
Will a Balance Sheet Statement done quarterly as of 2019-12-31 have the same numbers as a Balance Sheet Statement done annually as of 2019-12-31? Explain. What are the weights for ROA in the following equation? ROA = ROE ∗equity/assets + (cost of debt)∗debt/assets Explain why ROE>ROA>cost of debt. For time value of money problems, if the interest rate increase, will the Present Value increase? If the interest rate increase, will the Future Value increase? Explain.
On December 31, 2019, the Income Statement section of the worksheet is shown below. The balance...
On December 31, 2019, the Income Statement section of the worksheet is shown below. The balance of Ally Logan’s drawing account is $32,000. INCOME STATEMENT COLUMNS ACCOUNT NAME DEBIT CREDIT Income Summary $ 63,000 $ 69,000 Sales 250,000 Sales Returns and Allowances 6,100 Interest Income 760 Purchases 87,000 Freight In 3,900 Purchases Returns and Allowances 2,900 Purchases Discounts 3,500 Sales Salaries Expense 53,000 Office Salaries Expense 20,100 Office Supplies Expense 860 Utilities Expense 5,100 Payroll Taxes Expense 2,700 Uncollectible Accounts...
INCOME STATEMENT (IN MILL$): January 1, 2019 – December 31, 2019 Revenue = 400; Gross Profit...
INCOME STATEMENT (IN MILL$): January 1, 2019 – December 31, 2019 Revenue = 400; Gross Profit Margin = 30%; Operating Expenses (before depreciation) = 20; Depreciation = 20; Interest = 10; Average Tax Rate =40%; Preferred Dividend = 5; Common Dividend= 7; # of shares outstanding=10 million; Per Share Price of Common Stock = $50.00 BALANCE SHEET (IN MILL$): December 31, 2019 Cash = 5; A/R = 20; Inventory = 55; Net Fixed Asset = 120; Accounts Payable= 10; Accrued...
By the year Ending 12/31/2019, ABC Corporation's Balance Sheet & Income Statements show the following details...
By the year Ending 12/31/2019, ABC Corporation's Balance Sheet & Income Statements show the following details 1. Net Credit Sales = $ 450,000 2. Account Receivable = $ 50,000 This means on Avg the Collection Period (ACP) is about =    50 days 30 days 45 Days 28 days
Using the information below, Complete the Cash Flow Statement for Jenna Jam’s on 31 December 2019....
Using the information below, Complete the Cash Flow Statement for Jenna Jam’s on 31 December 2019. Cash 01/01/2019 272,000 Cash 31/12/2019 ???? Depreciation on Motor Vehicle 9,000 Owner investment 90,000 Interest on Loan Payable 4,700 Payment for purchase of Motor Vehicle 21,800 Collections from customers 283,000 Owner withdrawals 91,000 Payment of wages 121,000 Cash received for sale of Land 580,000 Payment to suppliers 345,000
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT