Fundamentals of Corporate Finance
11th Edition
ISBN: 9780077861704
Author: Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Bradford D Jordan Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 15QP
Summary Introduction
To prepare: The combined common-size, and common-base year balance sheets for the year 2015 of the Company JD.
Introduction:
The common-size statement is a standardized financial statement that records all the items in terms of percentages. The items in the income statement are shown as a percentage of sales and the items in the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
In cell D22, by using cell references, calculate the total long-term assets for year 2014 Use the relevant cells from the given data in the balance sheet. In call D23, by using a cell reference, calculate the total assets for year 2014. Refer to the relevant cell from the given data in the balance sheet. Note: The total assets must equal the total liabilities and owners' equity." in cell D18, by using cell references, calculate the total current assets for year 2014. Use the relevant cells in the balance sheet. In cell D16, by using cell references, calculate the accounts receivable for year 2014. Use the relevant cells in the balance sheet, in cell H14, by using cell references, calculate the accounts payable for year 2014. Use the relevant cells from the given cata in the balance sheet. In cell H22, by using cell references, calculate the total owners' equity for year 2014. Use the relevant cells from the given data in the balance sheet. In cell H18, by using cell references,…
Select 2017 Year From The Given Data In Image And Find The Following thing:1) Balance Sheet Growth - (TOTAL ASSETS CURRENT YEAR- TOTAL ASSETS CURRENT YEAR) / TOTAL ASSETS PREVIOUS YEAR.2) Sales.3) Financial Exp as a % of Sales4) EBIT5) Financial Cost / Interest Expense
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 600,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
Accounts Payable
Accrued Expenses
Accounts Receivable
Cash
Inventory
Fixed Assets
Marketable Securities
Mortgage Payable
Owner's Capital
Prepaid Insurance
85,000.00
Chapter 3 Solutions
Fundamentals of Corporate Finance
Ch. 3.1 - Prob. 3.1ACQCh. 3.1 - Prob. 3.1BCQCh. 3.2 - Prob. 3.2ACQCh. 3.2 - Name two types of standardized statements and...Ch. 3.3 - What are the five groups of ratios? Give two or...Ch. 3.3 - Given the total debt ratio, what other two ratios...Ch. 3.3 - Turnover ratios all have one of two figures as the...Ch. 3.3 - Profitability ratios all have the same figure in...Ch. 3.4 - Return on assets, or ROA, can be expressed as the...Ch. 3.4 - Return on equity, or ROE, can be expressed as the...
Ch. 3.5 - Prob. 3.5ACQCh. 3.5 - Prob. 3.5BCQCh. 3.5 - Prob. 3.5CCQCh. 3.5 - Prob. 3.5DCQCh. 3 - Prob. 3.1CTFCh. 3 - Prob. 3.2CTFCh. 3 - What is the correct formula for computing the...Ch. 3 - Prob. 3.5CTFCh. 3 - Current Ratio [LO2] What effect would the...Ch. 3 - Current Ratio and Quick Ratio [LO2] In recent...Ch. 3 - Prob. 3CRCTCh. 3 - Prob. 4CRCTCh. 3 - Prob. 5CRCTCh. 3 - Prob. 6CRCTCh. 3 - Prob. 7CRCTCh. 3 - Prob. 8CRCTCh. 3 - Prob. 9CRCTCh. 3 - Industry-Specific Ratios [LO2] There are many ways...Ch. 3 - Prob. 11CRCTCh. 3 - Prob. 12CRCTCh. 3 - Calculating Liquidity Ratios [LO2] SDJ, Inc., has...Ch. 3 - Calculating Profitability Ratios [LO2] Shelton,...Ch. 3 - Calculating the Average Collection Period [LO2]...Ch. 3 - Calculating Inventory Turnover [LO2] The Green...Ch. 3 - Calculating Leverage Ratios [LO2] Levine, Inc.,...Ch. 3 - Calculating Market Value Ratios [LO2] Makers Corp....Ch. 3 - DuPont Identity [LO4] If Roten Rooters, Inc., has...Ch. 3 - DuPont Identity [LO4] Zombie Corp. has a profit...Ch. 3 - Prob. 9QPCh. 3 - Prob. 10QPCh. 3 - Prob. 11QPCh. 3 - Equity Multiplier and Return on Equity [LO3] SME...Ch. 3 - Just Dew It Corporation reports the following...Ch. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Calculating Financial Ratios [LO2] Based on the...Ch. 3 - Using the DuPont Identity [LO3] Y3K, Inc., has...Ch. 3 - Days Sales in Receivables [LO2] A company has net...Ch. 3 - Ratios and Fixed Assets [LO2] The Caughlin Company...Ch. 3 - Profit Margin [LO4] In response to complaints...Ch. 3 - Return on Equity [LO2] Firm A and Firm B have...Ch. 3 - Calculating the Cash Coverage Ratio [LO2] Ugh...Ch. 3 - Cost of Goods Sold [LO2] W B Corp. has current...Ch. 3 - Prob. 25QPCh. 3 - Some recent financial statements for Smolira Golf...Ch. 3 - DuPont Identity [LO3] Construct the DuPont...Ch. 3 - Prob. 28QPCh. 3 - Market Value Ratios [LO2] Smolira Golf Corp. has...Ch. 3 - Tobins Q [LO2] What is Tobins Q for Smolira Golf?...Ch. 3 - Using the financial statements provided for SS...Ch. 3 - Mark and Todd agree that a ratio analysis can...Ch. 3 - Compare the performance of SS Air to the industry....
Knowledge Booster
Similar questions
- Perform a vertical analysis of the MLC balance sheet (Table 4-4) forDecember 31, 2012.arrow_forwardUsing the “Statement of Income” worksheet, center the financial statement titles across the data below and bold the company name Thom-Pierre Consultants (TPC) Quarterly Schedule of Revenue For the year December 31, 2018 QTR1 QTR2 QTR3 QTR4 2018 Sales 290000 320000 320000 490000 1,420,000 Interest 102500 175000 180000 54000 511,500 Investment Income 13000 9500 10000 20000 52,500 Other 16000 25000 19500 29000 89,500 Total 421,500 529,500 529,500 593,000 2,073,500 Thom-Pierre Consultants (TPC) COMPARITIVE INCOME STATEMENT for years ended 31 December 2018 2019 Revenues and gains *Sales revenue *Interest revenue *Investment Income *Other revenue Total revenue and gains Expenses and losses **Cost of goods sold 460,000 **Selling…arrow_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_forward
- I need assistance on the following regarding the attached balance sheet and income statement: Required: a) Calculate the following financial ratios for 2016 and 2017 13. Debt-to-equity ratio 14. Times-interest-earned ratio 15. Operating-cash-flow-to-capital-expenditures ratioarrow_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Secuities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 220,000 200,000 160,000 P445,000 P380,000 245,000 Operating Expenses: Fixed Assets Selling Expenses 22,000 25,000 Total…arrow_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Securities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 245,000 220,000 Operating Expenses: Fixed Assets 200,000 160,000 Selling Expenses 22,000 25,000 Total Assets P445,000…arrow_forward
- Below is the balance sheet and income statement for Chin Corporation. You are needed to analyze the financial statements. Use the horizontal, vertical, ratio methods to analyze the financial statements. For the vertical and horizontal analysis, type the accounts and dollar values for the years 2018 and 2017 (as listed on the financial statements even if there is no dollar value for an account). For the ratio analysis, make sure to compute 2 ratios from each section. Income Statement Period Ending: 12/31/2018 12/31/2017 Total Revenue $76,512,000 $78,291,000 Cost of Revenue $54,884,000 $56,586,000 Gross Profit $21,628,000 $21,706,000 Operating Expenses Research and Development $0 $0 Sales, General, and Admin. $13,886,000 $13,599,000 Non-Recurring Items $0 $0 Other Operating Items $0 $0 Operating Income $7,832,000 $8,079,000 Add'l income/expense items -$323,000…arrow_forwardChapter 5, page 344 and 349: EA12. 5.3 Using the following Balance Sheet summary information, calculate for the two years presented: A. working capital B. current ratio 12/31/2018 12/31/2019 $76,000 48,000 Current assets $295,000 Current liabilities 163,500 After computing liquidity ratios, comment on the performance of an entity using acceptable standards of liquidity performancearrow_forwardPlease Complete the Following: 1. Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement", use total assets on the balance sheet and net sales on the income statement for your vertical analysis. 2. Using the balance sheet and income statement, complete the ratios on the tab labeled "Ratios" 3. Answer the final OBSERVATION QUESTION (listed under Ratios calculations) Consolidated Balance Sheets (USD $) 12/31/2020 Vertical Analysis 12/31/2019 Vertical Analysis Horizontal Analysis In Millions, unless otherwise specified Current Assets: Cash and Cash Equivalents $1,723 $1,929 Receivables, net 1,484 1,398 Merchandise Inventories 11,079 11,057 Other Current Assets 1,016 895 Total Current Assets 15,302 15,279 Property and Equipment, at…arrow_forward
- Use the following information to answer questions 1 - 8 Consider the following abbreviated financial statements for Xinghua: XINGHUA 2014 and 2015 Partial Balance Sheets Assets Liabilities and Owners Equity 2014 2015 2014 2015 Current assets $ 924 $ 1,002 Current liabilities $ 370 $ 428 Net fixed assets 3,917 4,556 Long-term debt 2, 006 2, 142 Equity 2,465 2,988 XINGHUA 2015 Income Statement Sales $ 11,295 Costs 5,535 Depreciation 1,020 Interest paid 180 The tax rate is 35%. Long term debt trades at 128% of par. The firm has 500 shares outstanding. Free Cash Flow to the Firm and the Free Cash Flow to Equity are both expected to grow at 2% forever. The weighted average cost of capital is 16%. The cost of equity is 24%.1. What is the change in net working capital for 2015? $ 2. What is the change in gross fixed assets, i. e. capital expenditures, for 2015? $_ What is the Net Income for 2015? $ 3. 4. What is the Free Cash Flow to the Firm for 2015? $ What is the Value of the Firm…arrow_forward15. Using the information above calculate the net income/ profit, total assets,total debt, total equity,current assets and current liabilities for the year 2016 and choose the correct belowarrow_forwardThe comparative financial statements of Global Technology are as follows: Review the worksheet RATIOA that follows these requirements. You have been asked to perform a ratio analysis of this company for 2012.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning