What would the Profitability ratio be and the formula on excel? Lola's Company Balance Sheet December 31st, 2020 Assets Cash and Cash Equivalents $100,000 Accounts Receivable $150,000 Inventory $200,000 Prepaid Expenses $50,000 Property, Plant and Equipment $500,000 Total Assets $1,000,000 Liabilities Accounts Payable $100,000 Notes Payable $200,000 Accrued Expenses $50,000 Total Liabilities $350,000 Owner's Equity Common Stock $250,000 Retained Earnings $400,000 Total Owner's Equity $650,000 Total Liabilities and Owner's Equity $1,000,000 Statement of Owner's Equity December 31st, 2020 Owner's Equity at Beginning of Year $400,000 Net Income for the Year $130,000 Issuance of Common Stock $50,000 Dividends Paid ($30,000) Owner's Equity at End of Year $550,000 Lola's Company Statement of Cash Flow December 31st, 2020 Cash Flows from Operating Activities Net Income Depreciation Expense $100,000 $50,000 Increase in Accounts Receivable ($30,000) Increase in Inventory Decrease in Prepaid Expenses $10,000 ($20,000) Net Cash Provided by Operating Activities $110,000 Cash Flows from Investing Activities Purchase of Property, Plant and Equipment ($100,000) Net Cash Used in Investing Activities ($100,000) Cash Flows from Financing Activities Proceeds from Issuance of Common Stock $50,000 Repayment of Notes Payable ($30,000) Net Cash Provided by Financing Activities $20,000 Net Increase in Cash and Cash Equivalents $30,000 Income Statement December 31st, 2020 Revenue Sales Revenue $500,000 Interest Income $10,000 Total Revenue $510,000 Expenses Cost of Goods Sold ($200,000) Depreciation Expense ($50,000) Salaries and Wages Expense ($100,000) Rent Expense ($30,000) Total Expenses ($380,000) Net Income $130,000
What would the Profitability ratio be and the formula on excel? Lola's Company Balance Sheet December 31st, 2020 Assets Cash and Cash Equivalents $100,000 Accounts Receivable $150,000 Inventory $200,000 Prepaid Expenses $50,000 Property, Plant and Equipment $500,000 Total Assets $1,000,000 Liabilities Accounts Payable $100,000 Notes Payable $200,000 Accrued Expenses $50,000 Total Liabilities $350,000 Owner's Equity Common Stock $250,000 Retained Earnings $400,000 Total Owner's Equity $650,000 Total Liabilities and Owner's Equity $1,000,000 Statement of Owner's Equity December 31st, 2020 Owner's Equity at Beginning of Year $400,000 Net Income for the Year $130,000 Issuance of Common Stock $50,000 Dividends Paid ($30,000) Owner's Equity at End of Year $550,000 Lola's Company Statement of Cash Flow December 31st, 2020 Cash Flows from Operating Activities Net Income Depreciation Expense $100,000 $50,000 Increase in Accounts Receivable ($30,000) Increase in Inventory Decrease in Prepaid Expenses $10,000 ($20,000) Net Cash Provided by Operating Activities $110,000 Cash Flows from Investing Activities Purchase of Property, Plant and Equipment ($100,000) Net Cash Used in Investing Activities ($100,000) Cash Flows from Financing Activities Proceeds from Issuance of Common Stock $50,000 Repayment of Notes Payable ($30,000) Net Cash Provided by Financing Activities $20,000 Net Increase in Cash and Cash Equivalents $30,000 Income Statement December 31st, 2020 Revenue Sales Revenue $500,000 Interest Income $10,000 Total Revenue $510,000 Expenses Cost of Goods Sold ($200,000) Depreciation Expense ($50,000) Salaries and Wages Expense ($100,000) Rent Expense ($30,000) Total Expenses ($380,000) Net Income $130,000
Fundamentals Of Financial Management, Concise Edition (mindtap Course List)
10th Edition
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Eugene F. Brigham, Joel F. Houston
Chapter3: Financial Statements, Cash Flow, And Taxes
Section: Chapter Questions
Problem 19SP
Related questions
Question
Transcribed Image Text:What would the Profitability ratio be
and the formula on excel?
Lola's Company
Balance Sheet
December 31st, 2020
Assets
Cash and Cash Equivalents $100,000
Accounts Receivable $150,000
Inventory $200,000
Prepaid Expenses $50,000
Property, Plant and Equipment $500,000
Total Assets $1,000,000
Liabilities
Accounts Payable $100,000
Notes Payable $200,000
Accrued Expenses $50,000
Total Liabilities $350,000
Owner's Equity
Common Stock $250,000
Retained Earnings $400,000
Total Owner's Equity $650,000
Total Liabilities and Owner's Equity $1,000,000
Statement of Owner's Equity
December 31st, 2020
Owner's Equity at Beginning of Year
$400,000
Net Income for the Year
$130,000
Issuance of Common Stock
$50,000
Dividends Paid
($30,000)
Owner's Equity at End of Year
$550,000
Lola's Company
Statement of Cash Flow
December 31st, 2020
Cash Flows from Operating Activities
Net Income
Depreciation Expense
$100,000
$50,000
Increase in Accounts Receivable ($30,000)
Increase in Inventory
Decrease in Prepaid Expenses
$10,000
($20,000)
Net Cash Provided by Operating Activities
$110,000
Cash Flows from Investing Activities
Purchase of Property, Plant and Equipment
($100,000)
Net Cash Used in Investing Activities
($100,000)
Cash Flows from Financing Activities
Proceeds from Issuance of Common Stock
$50,000
Repayment of Notes Payable
($30,000)
Net Cash Provided by Financing Activities
$20,000
Net Increase in Cash and Cash Equivalents
$30,000
Income Statement
December 31st, 2020
Revenue
Sales Revenue $500,000
Interest Income $10,000
Total Revenue
$510,000
Expenses
Cost of Goods Sold ($200,000)
Depreciation Expense ($50,000)
Salaries and Wages Expense ($100,000)
Rent Expense ($30,000)
Total Expenses
($380,000)
Net Income
$130,000
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning