Managerial Accounting
3rd Edition
ISBN: 9780077826482
Author: Stacey M Whitecotton Associate Professor, Robert Libby, Fred Phillips Associate Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 3.3GBP
To determine
Introduction:
Vertical analysis help to express each financial statement line item as a percentage of the base year.
To compute:
The percentage of assets of the company that are financed by shareholder’s equity and by total liabilities.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
When using vertical analysis, we express balance sheet accounts as a percentage of a. Total assets. b. Total liabilities. c. Total stockholders’ equity. d. Sales.
Calculate the following ratios based on the balance sheet, income statement and cash flow prepared in question
ROE
Return on Capital Employed (post-tax)
Net Profit Margin
EBITDA Margin
Effective Tax Rate
Operating Cost Ratio
Gross Profit Margin
Total Asset Turnover Ratio
Fixed Asset Turnover Ratio
Receivables Turnover Ratio
Leverage Ratio [Avg. Total Assets / Avg. Total Equity]
FCF / EBITDA
Interest Coverage Ratio
Debt Service Coverage Ratio
Basic EPS (Assume Face Value of each share is INR 10)
Debt : Equity Ratio
Income Statement (INR Cr)
Units
Mar/14
Saleable Units
4,570
Revenues
Gross Revenues
INR Cr
2,116
Less: Environment Cess
INR Cr
5
Net Revenues
INR Cr
2,121
Growth (%)
-1.9%
Expenses
O&M Expenses (% of Project Costs)
INR Cr
146
YoY Escalation
5.72%
EBITDA
INR Cr
1,974
Margin (%)
93.1%
Book Depreciation
INR Cr
439
Interest Expenses
INR…
Requirements:
a. Prepare horizontal analysis based on the above statements presented (for percent: round of your answers to 2 decimal places) Music Lover, Inc.xlsx
b. Evaluate the company's financial position and results of operation using the comparative statement analysis
i. Short-term solvency analysis
ii. Long-term financial position analysis iii. Operating efficiency and profitability analysis
Chapter 13 Solutions
Managerial Accounting
Ch. 13 - Prob. 1QCh. 13 - Prob. 2QCh. 13 - What is ratio analysis? Why is it useful?
Ch. 13 - What benchmarks are commonly used for interpreting...Ch. 13 - Prob. 5QCh. 13 - Why are some analyses called horizontal and others...Ch. 13 - Slow Cellar’s current ratio increased from 1.2 to...Ch. 13 - From last year to this year. Colossal Company’s...Ch. 13 - From last year to this year, Berry Barn reported...Ch. 13 - Prob. 10Q
Ch. 13 - Prob. 1MCCh. 13 - Prob. 2MCCh. 13 - Prob. 3MCCh. 13 - Prob. 4MCCh. 13 - Prob. 5MCCh. 13 - Prob. 6MCCh. 13 - Prob. 7MCCh. 13 - Prob. 8MCCh. 13 - Prob. 9MCCh. 13 - Prob. 1MECh. 13 - Prob. 2MECh. 13 - Prob. 3MECh. 13 - Prob. 4MECh. 13 - Prob. 5MECh. 13 - Prob. 6MECh. 13 - Prob. 7MECh. 13 - Prob. 8MECh. 13 - Prob. 9MECh. 13 - Prob. 10MECh. 13 - Prob. 11MECh. 13 - Prob. 12MECh. 13 - Prob. 13MECh. 13 - Prob. 14MECh. 13 - Prob. 1ECh. 13 - Prob. 2ECh. 13 - Prob. 3ECh. 13 - Prob. 4ECh. 13 - Prob. 5ECh. 13 - Prob. 6ECh. 13 - Prob. 7ECh. 13 - Computing and Interpreting Liquidity Ratios...Ch. 13 - Prob. 9ECh. 13 - Prob. 10ECh. 13 - Prob. 11ECh. 13 - Prob. 12ECh. 13 - Prob. 13ECh. 13 - Analyzing the Impact of Selected Transactions on...Ch. 13 - Prob. 15ECh. 13 - Prob. 1.1GAPCh. 13 - Prob. 1.2GAPCh. 13 - Prob. 2.1GAPCh. 13 - Prob. 2.2GAPCh. 13 - Prob. 2.3GAPCh. 13 - Prob. 2.4GAPCh. 13 - Prob. 2.5GAPCh. 13 - Prob. 2.6GAPCh. 13 - Prob. 2.7GAPCh. 13 - Prob. 2.8GAPCh. 13 - Prob. 3.1GAPCh. 13 - Prob. 3.2GAPCh. 13 - Prob. 3.3GAPCh. 13 - Prob. 4.1GAPCh. 13 - Prob. 4.2GAPCh. 13 - Prob. 4.3GAPCh. 13 - Prob. 5.1GAPCh. 13 - Prob. 5.2GAPCh. 13 - Prob. 5.3GAPCh. 13 - Prob. 5.4GAPCh. 13 - Prob. 6.1GAPCh. 13 - Prob. 6.2GAPCh. 13 - Prob. 7GAPCh. 13 - Prob. 1.1GBPCh. 13 - Prob. 1.2GBPCh. 13 - Prob. 2.1GBPCh. 13 - Prob. 2.2GBPCh. 13 - Prob. 2.3GBPCh. 13 - Prob. 2.4GBPCh. 13 - Prob. 2.5GBPCh. 13 - Prob. 2.6GBPCh. 13 - Prob. 2.7GBPCh. 13 - Prob. 2.8GBPCh. 13 - Prob. 3.1GBPCh. 13 - Prob. 3.2GBPCh. 13 - Prob. 3.3GBPCh. 13 - Prob. 4.1GBPCh. 13 - Prob. 4.2GBPCh. 13 - Prob. 4.3GBPCh. 13 - Prob. 5.1GBPCh. 13 - Prob. 5.2GBPCh. 13 - Prob. 5.3GBPCh. 13 - Prob. 5.4GBPCh. 13 - Prob. 6.1GBPCh. 13 - Prob. 6.2GBPCh. 13 - Prob. 7GBP
Knowledge Booster
Similar questions
- Please fill out vertical analysis of this balance sheet to determine component percentage of assets liabilities and stockholders equity based on data. Round percentages to the nearest hundredths percentarrow_forwardMargaret O'Flaherty, a portfolio manager for MCF Investments, is considering investing in Alpine Chemical 7% bonds, which mature in 10 years. She asks you to analyze the company to determine the riskiness of the bonds. Alpine Chemical Company Financial Statements Years Ended December 31, ($ in millions) 20X1 20X2 20X3 20X4 20X5 20X6 Assets Cash $ 55 $ 1,637 2,021 190 $ 2,143 1,293 157 249 $ 1,394 1,258 3,493 1,322 Accounts receivable 3,451 1,643 2,087 Inventories 945 Other current assets 17 27 55 393 33 171 5,097 6,181 Current assets 3,114 5,038 2,543 2,495 3,986 5,757 3,138 3,865 2,707 5,619 2,841 2,778 5,265 4,650 2,177 2,473 Gross fixed assets 7,187 3,893 3,465 2,716 Less: Accumulated depreciation Net fixed assets 2,619 3,294 Total assets $6,338 $5,609 $5,485 $6,605 $7,813 $8,559 Liabilities and net worth Notes payable Accounts payable $1,300 338 $ 525 2$ 750 $1,750 $1,900 673 638 681 743 978 Accrued liabilities 303 172 359 359 483 761 Current liabilities 1,501 1,985 1,997 1,457…arrow_forwardSelect the Income Statements and Balance Sheets of Aramco Saudi from the calculate the following financial ratios: a. Long-term debt ratios b. Total debt ratio c. Times interest earned d. Cash coverage ration e. current ratio f. Quick ratio g. Operating profit margin h. Inventory Turnover i. Days in inventory j. Average collection period k. Return on equity I. Return on assets m. Payout rationsarrow_forward
- The current ratio isa. calculated by dividing current liabilities by current assets. b. used to evaluate a company's liquidity and short-term debt paying ability c. used to evaluate a company's solvency and long-term debt paying ability. d. calculated by subtracting current liabilities from current assets.arrow_forwardA-1: determine the amount of current assets and current liabilities for each company A-2: compute the current ratio for each company B: assuming that all assets and liabilities are listed above, compute the debt to assets ratio for each company C-1: determine which company has the greater finiancial risk in the short term C-2: determine which company has the greater financial risk in the long termarrow_forward5. Know the calculations for all of the following ratios (see ratio sheet that can be used on the exam) and know the category (listed in Question 4) they fall in: Formula Category/Use Ratio Working Capital Current Assets - Current Liabilities Net credit sales/Average Accounts Receivable Turnover accounts receivable Asset Turnover Net sales/Average total assets Net income/Average total stockholders' equity Total liabilities/Total stockholders equity Net income/Net sales Return on Equity (ROE) Debt to equity Return on Sales (ROS) (also known as Net Margin Current Assets/Current Liabilities Cost of goods sold/Average inventory Quick assets/Current Current Ratio Inventory Turnover Quick Ratio liabilities Dividend Yield Dividends per share/Market price per share Net earnings available for common stock/Number of outstanding common shares Net income/Average total Earnings per Share (EPS) Return on Investment (ROI) assets Price Earnings Ratio (P/E) Market price per share/Earnings per share…arrow_forward
- Define each of the following terms:a. Liquid assetb. Liquidity ratios: current ratio; quick (acid test) ratioc. Asset management ratios: inventory turnover ratio; days sales outstanding (DSO);fixed assets turnover ratio; total assets turnover ratiod. Debt management ratios: total debt to total capital; times-interest-earned (TIE) ratioe. Profitability ratios: operating margin; profit margin; return on total assets (ROA);return on common equity (ROE); return on invested capital (ROIC); basic earning power (BEP) ratiof. Market value ratios: price/earnings (P/E) ratio; market/book (M/B) ratio; enterprise value/EBITDA ratio g. DuPont equation; benchmarking; trend analysish. “Window dressing” techniquesarrow_forwardAssume the following relationships for the Caulder Corp.: Sales/Total assets Return on assets (ROA) Return on equity (ROE) Calculate Caulder's profit margin and debt-to-capital ratio assuming the firm uses only debt and common equity, so total assets equal total invested capital. Do not round intermediate calculations. Round your answers to two decimal places. Profit margin: Debt-to-capital ratio: % % 1.9x 8.0% 13.0%arrow_forwardMatch each ratio that follows to its use. Items may be used more than once. Clear All price-earnings (P/E) ratio working capital return on total assets ratio of liabilities to stockholders’ equity quick ratio indicate the ability to pay current liabilities assess the profitability of the assets indicate how much of the company is financed by debt and equity indicate future earnings prospects indicate instant debt-arrow_forward
- Define each of the following terms: a. Liquid asset b. Liquidity ratios: current ratio; quick ratio c. Asset management ratios: inventory turnover ratio d. Debt management ratios: total debt to total capital; times-interest-earned (TIE) ratio e. Profitability ratios: profit margin; return on total assets (ROA); return on common equity (ROE); return on invested capital (ROIC); basic earning power (BEP) ratio f. Market value ratios: price/earnings (P/E) ratio; market/book (M/B) ratio; enterprise value/EBITDA ratioarrow_forwardEvaluation: Financial Statements Analysis and Interpretations Instructions: 1. Using the provided data below, prepare a Statement of Financial Position - Vertical Analysis. 2. Compute for the following financial ratios and provide interpretation for each item. a. Current Ratio b. Working Capital c. Debt-to-Equity Ratio d. Debt Ratio e. Asset Turnover Ratio 3. You may use any desired business name. 4. Use the space provided for your answer. Given: 2017 2016 P 358,950.00 P 184,560.00 P 365,450.00 P 450,355.00 P 252,260.00 P 653,550.00 P 300,000.00 P 800,000.00 P 943,105.00 P 65,000.00 P 277,145.00 P 68,505.00 P 285,000.00 P 235,000.00 P 345,650.00 P 745,000.00 P 150,000.00 P 700,000.00 P 800,000.00 85,000.00 Accounts Payable Accrued Expenses Accounts Receivable Cash Inventory Fixed Assets Marketable Securities Mortgage Payable Owner's Capital Prepaid Insurancearrow_forwardDefinitional problems: Listed are 11 terms that relate to ratio analysis:1. Book value per share2.Inventoryturnover3. Debt-to-equity ratio4. Average collection period5. Average sales period6. Return on common equity7. Earnings per share8. Price/earnings ratio9. Return on total assets10. Current ratio11. Accounts-receivable turnoverChoose the financial ratio or term from the list that most appropriately completes each of the following statements:1. The__________ tends to have an effect on the market price per share asreflected in the price/earnings ratio.2. The__________ indicates whether a stock is relatively cheap or relativelyexpensive in relation to current earnings. 3. The________ measures the amount that would be distributed to holders of common stock if all assets were sold at their balance-sheet carrying amount and if all creditors were paid off.4. The_____________ is a rough measure of how many times a company'saccounts…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,