Question

In: Finance

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category	Prior year	Current year
Accounts payable	41,400	45,000
Accounts receivable	115,200	122,400
Accruals	16,200	13,500
Additional paid in capital	200,000	216,660
Cash	???	???
Common Stock @ par value	37,600	42,000
COGS	131,400	175,511.00
Depreciation expense	21,600	23,085.00
Interest expense	16,200	16,974.00
Inventories	111,600	115,200
Long-term debt	135,000	138,052.00
Net fixed assets	378,667.00	399,600
Notes payable	59,400	64,800
Operating expenses (excl. depr.)	50,400	65,892.00
Retained earnings	122,400	136,800
Sales	255,600	335,712.00
Taxes	9,900	18,931.00

What is the current year's return on assets (ROA)?

What is the current year's return on equity (ROE)?

What is the current year's entry for long-term debt on a common-sized balance sheet?

Solutions

Expert Solution

Answer 1)

Current Year ROA = Net Income / Average Total Assets *100

Net Income =

Gross Profit = Sales - COGS

Gross Profit = 335,712 - 175,511 = 160,201

Net Profit = Gross Profit - Operating Expenses - Depreciation - Interest - Taxes

Net Profit = 160,201 - 65,892 - 23085 - 16974 - 18931 = 35,319

Current Year Total Assets = Liabilities + Equity

= Accounts Payable + Accruals + Additional paid in capital + Common stock + long Term Debt + Notes Payable + Retained Earnings

= 45,000 + 13,500 + 42,000 + 216,660 + 138,052 + 64,800 + 136,800 = 656,812

Prior Year Total Assets = Prior year liab + Prior year equity

= Accounts Payable + Accruals + Additional paid in capital + Common stock + long Term Debt + Notes Payable + Retained Earnings

= 41,400 + 16,200 + 200,000 + 37,600 + 135,000 + 59,400 + 122,400 = 612,000

Average Total Assets = (656,812 + 612,000) / 2

Average Total Assets = 634,406

Current Year ROA = 35,319 / 634,406 *100 = 5.57%

Answer 2)

Current Year ROE = Net Income / Total Equity *100

Current Year Total Equity = Common Stock + additional paid in capital + Retained Earnings

= 42,000+216,660+136,800 = 395,460

Current Year ROE = 35,319 / 395,460 * 100 = 8.93%

Answer 3)

A common size balance sheet represent the line item as a percentage of the total value. it is used to evaluate financial statements. Long Term Debt will be expressed as a percentage of Total Liabilities and Shareholder's equity.

Long Term Debt in monetary terms will be 138,052

Long Term Debt in % terms as a % of Total Liab and Shareholder's Equity will be 21.02%

Working

Total Liabilities and Shareholder's Equity = 656,812

Long Term Debt = 138.052

% = 138,052/656,812 = 21.02%

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660 Cash ??? ??? Common Stock @ par value 37,600 42,000 COGS 131,400 175,511.00 Depreciation expense 21,600 23,085.00 Interest expense 16,200 16,974.00 Inventories 111,600 115,200 Long-term debt 135,000 138,052.00 Net fixed assets 378,667.00 399,600 Notes payable 59,400 64,800 Operating expenses (excl. depr.) 50,400 65,892.00 Retained earnings 122,400 136,800 Sales 255,600 335,712.00 Taxes 9,900 18,931.00 What is the current year's...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660 Cash ??? ??? Common Stock @ par value 37,600 42,000 COGS 131,400 171,352.00 Depreciation expense 21,600 23,794.00 Interest expense 16,200 16,828.00 Inventories 111,600 115,200 Long-term debt 135,000 139,414.00 Net fixed assets 379,043.00 399,600 Notes payable 59,400 64,800 Operating expenses (excl. depr.) 50,400 62,481.00 Retained earnings 122,400 136,800 Sales 255,600 337,867.00 Taxes 9,900 18,575.00 What is the firm's gross...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660 Cash ??? ??? Common Stock @ par value 37,600 42,000 COGS 131,400 178,223.00 Depreciation expense 21,600 23,852.00 Interest expense 16,200 16,649.00 Inventories 111,600 115,200 Long-term debt 135,000 138,605.00 Net fixed assets 379,258.00 399,600 Notes payable 59,400 64,800 Operating expenses (excl. depr.) 50,400 65,799.00 Retained earnings 122,400 136,800 Sales 255,600 337,010.00 Taxes 9,900 19,119.00 What is the firm's current...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660 Cash ??? ??? Common Stock @ par value 37,600 42,000 COGS 131,400 174,020.00 Depreciation expense 21,600 22,237.00 Interest expense 16,200 16,207.00 Inventories 111,600 115,200 Long-term debt 135,000 138,111.00 Net fixed assets 377,019.00 399,600 Notes payable 59,400 64,800 Operating expenses (excl. depr.) 50,400 66,669.00 Retained earnings 122,400 136,800 Sales 255,600 335,862.00 Taxes 9,900 19,078.00 What is the current year's...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660 Cash ??? ??? Common Stock @ par value 37,600 42,000 COGS 131,400 174,020.00 Depreciation expense 21,600 22,237.00 Interest expense 16,200 16,207.00 Inventories 111,600 115,200 Long-term debt 135,000 138,111.00 Net fixed assets 377,019.00 399,600 Notes payable 59,400 64,800 Operating expenses (excl. depr.) 50,400 66,669.00 Retained earnings 122,400 136,800 Sales 255,600 335,862.00 Taxes 9,900 19,078.00 What is the current year's...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660 Cash ??? ??? Common Stock @ par value 37,600 42,000 COGS 131,400 174,020.00 Depreciation expense 21,600 22,237.00 Interest expense 16,200 16,207.00 Inventories 111,600 115,200 Long-term debt 135,000 138,111.00 Net fixed assets 377,019.00 399,600 Notes payable 59,400 64,800 Operating expenses (excl. depr.) 50,400 66,669.00 Retained earnings 122,400 136,800 Sales 255,600 335,862.00 Taxes 9,900 19,078.00 What is the firm's net...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660 Cash ??? ??? Common Stock @ par value 37,600 42,000 COGS 131,400 174,020.00 Depreciation expense 21,600 22,237.00 Interest expense 16,200 16,207.00 Inventories 111,600 115,200 Long-term debt 135,000 138,111.00 Net fixed assets 377,019.00 399,600 Notes payable 59,400 64,800 Operating expenses (excl. depr.) 50,400 66,669.00 Retained earnings 122,400 136,800 Sales 255,600 335,862.00 Taxes 9,900 19,078.00 What is the current year's...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660 Cash ??? ??? Common Stock @ par value 37,600 42,000 COGS 131,400 172,470.00 Depreciation expense 21,600 23,655.00 Interest expense 16,200 16,316.00 Inventories 111,600 115,200 Long-term debt 135,000 138,084.00 Net fixed assets 377,704.00 399,600 Notes payable 59,400 64,800 Operating expenses (excl. depr.) 50,400 65,945.00 Retained earnings 122,400 136,800 Sales 255,600 335,333.00 Taxes 9,900 19,395.00 1. What is the entry...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660 Cash ??? ??? Common Stock @ par value 37,600 42,000 COGS 131,400 178,480.00 Depreciation expense 21,600 23,731.00 Interest expense 16,200 16,751.00 Inventories 111,600 115,200 Long-term debt 135,000 137,821.00 Net fixed assets 376,128.00 399,600 Notes payable 59,400 64,800 Operating expenses (excl. depr.) 50,400 65,598.00 Retained earnings 122,400 136,800 Sales 255,600 335,829.00 Taxes 9,900 19,235.00 What is the current year's...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500...

Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660 Cash ??? ??? Common Stock @ par value 37,600 42,000 COGS 131,400 172,399.00 Depreciation expense 21,600 22,198.00 Interest expense 16,200 16,520.00 Inventories 111,600 115,200 Long-term debt 135,000 139,799.00 Net fixed assets 376,264.00 399,600 Notes payable 59,400 64,800 Operating expenses (excl. depr.) 50,400 62,655.00 Retained earnings 122,400 136,800 Sales 255,600 336,548.00 Taxes 9,900 18,574.00 What is the firm's current...

Subjects