Question

[2] Financial ratios (58 points) Find the missing values on the balance sheet and the income statement of Pensacola Railroads (in S millions). Start with the balance sheet, and then continue with the income statement. You can use the following ratios: NOTE: USE AVERAGE RECEIVABLES AND INVENTORY Debt Ratio loterest Coverage Ratio CurreatRatio Quick Ratio Cash Ratio 0.4 1.4 0.2 Average Collection Period (average receivables) Tax rate 73 das 40% Marks: 28 for balance sheet, 30 for income statement.Balance Sheet Pensacola Railroad 2017 2016 20 34 26 80 Cash & lnventory Current Assets Eixed Assets 25 Total assets 105 Notes Pavable. Accounts Pavable Current Liabilities, 25 20 30 35 20 Long termDebt Equity 30 115 105 Uncome 2017 Sales COGS Otber costs. 10 20 EBIT lnterest, Earnings before tax Tax. Net ocome[2] Financial ratios (58 points) NOTE: use average inventory and receivables Balance Sheet Pensacola Railroad Marks 2017 2016 Cash & marketable securities Accounts Receivable Inventory 20 34 26 80 Current Assets 25 105 Fixed Assets Total assets Notes Payable Accounts Payable 25 30 20 35 Current Liabilities Long term Debt Equity 20 30 Total Liabilities+Equity 115 105 28Income Statement 2017 Marks Sales COGS Other costs Depreciation EBIT Interest Earnings before tax Tax Net Income 10 20 30 Selected ratios Debt Ratio Interest Coverage Ratio Current Ratio Quick Ratio Cash Ratio Inventory Tumover (average inventory) Average Collection Period (average receivables) Tax rate 0.4 0.2 73 days 40%how to get the numbers

0 0
Add a comment Improve this question Transcribed image text
Answer #1
2017 2016
Cash and marketable securities (55*0.2) 11.00 20.00 Total assets = Total liabilities+Equity = 115
Accounts receivable = 55*1-11 = 44.00 34.00 which is given.
Inventory 22.00 26.00 Next find current assets = Current liabilities*Current ratio = 55*1.4 = 77
Current assets (55*1.4) 77.00 80.00 Further, cash = Current liabilities*0.2 = 55*0.2 = 11
Fixed assets (115-77) 38.00 25.00 Quick assets = Current liabilities*1 = 55
Total assets 115.00 105.00 Accounts receivable = 55-cash = 55-11 = 44
Inventory = 77-11-44 = 22
Notes payable 25.00 20.00 Sales and COGS calculations are given.
Accounts payable 30.00 35.00 Equity = beginning balance+Net income = 30+5.63
Current liabilities 55.00 55.00 Long term debt = 115-53.63-55
Long term debt 6.38 20.00
Equity = (30.00+23.63) 53.63 30.00
Total liabilities+Equity 115.00 105.00
Sales 195.00
COGS 120.00
Other costs 10.00
Depreciation 20.00
EBIT 45.00
Interest (45/8) 5.63
Earnings before tax 39.38
Tax 15.75
Net income 23.63
WORKING NOTES FOR INCOME STATEMENT FIGURES:
Sales = Average receivables*365/73 = 39*365/73 = 195
COGS = Average inventory*5 = 24*5 = 120
Add a comment
Know the answer?
Add Answer to:
how to get the numbers [2] Financial ratios (58 points) Find the missing values on the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • [2] Financial ratios (58 points) Find the missing values on the balance sheet and the income...

    [2] Financial ratios (58 points) Find the missing values on the balance sheet and the income statement of Pensacola Railroads (in S millions). Start with the balance sheet, and then continue with the income statement. You can use the following ratios: NOTE: USE AVERAGE RECEIVABLES AND INVENTORY Debt Ratio loterest Coverage Ratio CurreatRatio Quick Ratio Cash Ratio 0.4 1.4 0.2 Average Collection Period (average receivables) Tax rate 73 das 40% Marks: 28 for balance sheet, 30 for income statement. Balance...

  • 2. Calculating Financial Ratios [LO2] Find the following financial ratios for Smolira Golf Corp. for 2018...

    2. Calculating Financial Ratios [LO2] Find the following financial ratios for Smolira Golf Corp. for 2018 (year-end figures reflect average values where appropriate): Assets Current assets Cash Accounts receivable Inventory Total SMOLIRA GOLF CORP. 2018 Balance Sheets Liabilities and Owners' Equity 2018 2018 Current liabilities $ 37,837 Accounts payable $ 42,582 27,766 Notes payable 16,200 42.632 Other 24 634 108,235 Total 83,416 145,000 Long-term debt Owners' equity Common stock and paid-in surplus Retained earnings Total Equity Total liabilities and owners'...

  • Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below....

    Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 499891 Operating Costs 359935 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 59989 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 69989 Prepare an income statement and a balance sheet for is company using the information provided. Calculate: 1. Current ratio 2. Quick ratio 3. NWC-to-total-Assets (Working capital to assets) 4. Ratio...

  • Use the attached Income Statement and Balance Sheet to compute the required financial ratios for Seward...

    Use the attached Income Statement and Balance Sheet to compute the required financial ratios for Seward Inc. and compare to the industry averages. After that, write a brief summary as to what each ratio is measuring and how Seward compares to the industry. For example, you may find that Seward's Inventory Turnover is not as high as the industry average, so they are either not managing their inventories or may be experiencing a decrease in sales. Seward Industries a. Compute...

  • 26. Calculating Financial Ratios (LO2] Find the following financial ratios for Smolira Golf Corp. (use year-end...

    26. Calculating Financial Ratios (LO2] Find the following financial ratios for Smolira Golf Corp. (use year-end figures rather than average values where appropriate): Assets 2017 2018 Short-term solvency ratios: SMOLIRA GOLF CORP. 2017 and 2018 Balance Sheets Liabilities and Owners' Equity 2018 2017 Current liabilities S 37857 Accounts payable S 36.722 27.766 Notes puble 19.00 42632 Other 19 SHO.255 Toal Long term debe S115.000 $ 34 35 42582 a. Current ratio. Accounts receivable 16.200 b. Quick ratio. 17.801 _36,310 $88.9...

  • 5. Calculate the 2015 financial ratios for Phocbe Corporation rounded to the nearest tenth and put...

    5. Calculate the 2015 financial ratios for Phocbe Corporation rounded to the nearest tenth and put a checkmark in tbe row in which Phorbe's ratios are better than the industry average: Ratio Gross Profit Margin Net Profit Margin Current Ratio Inventory Turnover Receivables Turnover Phoebe Corporation (2015) Industry Averages Phocbe is Better 55.0% 27.5% 3.3 % % 15.5 8.5 Select Financial Ratios What It Measures Eficiency of operations and product pricing Lisiency afher all expenses are considered Short-run debt-paying ability...

  • ne saved CILJUDI Check my work Problem 4-7 Financial Ratios (LO3) Here are simplified financial statements...

    ne saved CILJUDI Check my work Problem 4-7 Financial Ratios (LO3) Here are simplified financial statements for Phone Corporation in a recent year: points eBook INCOME STATEMENT (Figures in $ millions) Net sales Cost of goods sold Other expenses Depreciation Earnings before interest and taxes (EBIT) Interest expense Income before tax Taxes (at 35%) Net income Dividends $ 13,700 4,360 4,047 2,698 $ 2,595 715 $ 1,880 658 $ 1,222 $ 916 Print References BALANCE SHEET (Figures in $ millions)...

  • e following ratios are computed from the financial statements of the Wattawa Company. Compute the missing...

    e following ratios are computed from the financial statements of the Wattawa Company. Compute the missing amounts on the firm's financial statements. Quick Ratio 1.0 Current Ratio 1.5 Accounts Receivable Turnover 5 Debt Ratio 30% Times Interest Earned 3 Inventory Turnover 4 Note: 1) For ratios that call for an average balance, use the year-end value only. 2) All sales were on credit. Wattawa Company Income Statement For the year ended December 31, 2018 Sales ? Less: Cost of Goods...

  • Anyone know these values and can explain how to get them? Problem 2-6A Condensed balance sheet...

    Anyone know these values and can explain how to get them? Problem 2-6A Condensed balance sheet and income statement data for Sheffield Corp. are presented as follows Sheffield Corp Balance Sheets December 31 Assets Cash Receivables (net) Other current assets Long-term investments Property, plant, and equipment (net) Total assets Liabilities and Stockholder Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and stockholders' equity 2017 2016 83,300 103,300 62,000 523,300 $803,040 $31,140 23,140 75,300 86,300 60,000 483,300 728,040 s'...

  • PLEASE FIND THE FINANCIAL RATIOS IN BELOW Financial Ratios The financial statements for Jackson Enterprises (income...

    PLEASE FIND THE FINANCIAL RATIOS IN BELOW Financial Ratios The financial statements for Jackson Enterprises (income statement, statement of owner’s equity, and balance sheet) are shown. Jackson Enterprises Income Statement For Year Ended December 31, 20-- Revenue from sales:   Sales $170,000 Less: Sales returns and allowances 10,000 Net sales $160,000 Cost of goods sold: Merchandise inventory, January 1, 20-- $6,600 Estimated returns inventory, January 1, 20-- 1,400 $8,000 Purchases $92,870 Less: Purchases returns and allowances $1,896       Purchases discounts 1,888...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT