Adequate information: Ratio Value Formula Current Ratio 1.832716 Current Assets Current Liabilities Inventory Turnover 4.414239 Cost of Goods Sold Average Inventory A/R Turnover 8.333333 Net Sales Average Accounts Receivable Fixed Turnover 1.657982 Net Sales Average Fixed Assets LTD To Equity 0.843090 Long Term Debt Equity Times Interest Earned 1.833333 Earnings Before Interest And Tax Interest Net Profit Margin 0.016000 Net Profit Sales Return On Total Assets 0.018061 Net Income Total Assets Return On Equity 0.040307 Net Income Equity To compute: Figures marked with ‘ratio’ in the financial statements.

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 3, Problem 2P

a.

Summary Introduction

Adequate information:

Ratio Value Formula
Current Ratio 1.832716 Current AssetsCurrent Liabilities
Inventory Turnover 4.414239 Cost of Goods SoldAverage Inventory
A/R Turnover 8.333333 Net SalesAverage Accounts Receivable
Fixed Turnover 1.657982 Net SalesAverage Fixed Assets
LTD To Equity 0.843090 Long Term DebtEquity
Times Interest Earned 1.833333 Earnings Before Interest And TaxInterest
Net Profit Margin 0.016000 Net ProfitSales
Return On Total Assets 0.018061 Net Income Total Assets
Return On Equity 0.040307 Net IncomeEquity

To compute: Figures marked with ‘ratio’ in the financial statements.

a.

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Figure Calculated	Ratio Used for Calculation	Remark
Cost of Goods Sold	Inventory Turnover Ratio	Inventory value is given
Net Income	Return on Total Assets	Value of total asset is given
Equity	Return on Equity	Net income used to calculate
Long Term Debt	LTD To Equity	Equity value used
Sales	Net Profit Margin	Net profit used to find sales
Interest Expense	Times Interest Earned	Earnings before interest and tax used to calculate
Accounts Receivable	A/R Turnover	Sales figure already calculated
Net Plant and Equipment	Fixed Turnover	Sales figure used to find Average fixed assets and half of depreciation deducted to get closing value.

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 1

b)

Summary Introduction

To compute: Figures marked with ‘formula’ in the financial statements.

b)

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Formula to Be Calculated	Remark
Gross Profit	Sales − Cost Of Goods Sold
Earnings Before Interest and Tax	Gross Profit − Depreciation − Selling and Administration Expenses − Lease Expenses
Earnings Before Tax	Earnings Before Interest And Tax − Interest
Tax	Charged at 40 % of Earnings Before Tax
Total Current Assets	Cash + Accounts Receivable + Inventory
Accumulated Depreciation	Balancing Figure
Short Term Notes Payable	Balancing Figure
Total Liabilities and Owner’s Equity	Total Assets

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 2

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

4. Assume that you will be up for a promotion next month and you'd like to impress your boss with your data analytic skills. The company you work for normally books the current month's bad debit for the same amount as the prior month's actual accounts receivable write-offs. Using general accounting knowledge, explain why this process is not the best method. 5. Briefly describe Benford's Law. Draw a graph that exemplifies data which conforms to Benford's Law (i.e., what it should look like). And, briefly describe how auditors could utilize Benford's Law while conducting testwork.

Using Excel, create a table that shows the relationship between the interestearned and the amount deposited, as shown. we will first create the dollar amount column and the interest row, as shown . Next we will type into cell B3 the formula = $A3*B$2. We can now use the Fill command to copy the formula in other cells, resulting in the table as shown. Note that the dollar sign before A3 means column A is to remain unchanged in the calculations when the formula is copied into other cells. Also note that the dollar sign before 2 means that row 2 is to remain unchanged in calculations when the Fill command is used.

Damon Davis was working on a spreadsheet for the Drano Plumbing Company. He calculated that the net profit would be $50,000. He totaled the columns on the Balance Sheet as follows: debit, $400,000; and credit, $300,000. What was the most likely cause of this disparity? If this was not the case, how should he go about determining the cause of the error?

Answer 2

Question

Chapter 3, Problem 2P

a.

Summary Introduction

Adequate information:

Ratio Value Formula
Current Ratio 1.832716 Current AssetsCurrent Liabilities
Inventory Turnover 4.414239 Cost of Goods SoldAverage Inventory
A/R Turnover 8.333333 Net SalesAverage Accounts Receivable
Fixed Turnover 1.657982 Net SalesAverage Fixed Assets
LTD To Equity 0.843090 Long Term DebtEquity
Times Interest Earned 1.833333 Earnings Before Interest And TaxInterest
Net Profit Margin 0.016000 Net ProfitSales
Return On Total Assets 0.018061 Net Income Total Assets
Return On Equity 0.040307 Net IncomeEquity

To compute: Figures marked with ‘ratio’ in the financial statements.

a.

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Figure Calculated	Ratio Used for Calculation	Remark
Cost of Goods Sold	Inventory Turnover Ratio	Inventory value is given
Net Income	Return on Total Assets	Value of total asset is given
Equity	Return on Equity	Net income used to calculate
Long Term Debt	LTD To Equity	Equity value used
Sales	Net Profit Margin	Net profit used to find sales
Interest Expense	Times Interest Earned	Earnings before interest and tax used to calculate
Accounts Receivable	A/R Turnover	Sales figure already calculated
Net Plant and Equipment	Fixed Turnover	Sales figure used to find Average fixed assets and half of depreciation deducted to get closing value.

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 1

b)

Summary Introduction

To compute: Figures marked with ‘formula’ in the financial statements.

b)

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Formula to Be Calculated	Remark
Gross Profit	Sales − Cost Of Goods Sold
Earnings Before Interest and Tax	Gross Profit − Depreciation − Selling and Administration Expenses − Lease Expenses
Earnings Before Tax	Earnings Before Interest And Tax − Interest
Tax	Charged at 40 % of Earnings Before Tax
Total Current Assets	Cash + Accounts Receivable + Inventory
Accumulated Depreciation	Balancing Figure
Short Term Notes Payable	Balancing Figure
Total Liabilities and Owner’s Equity	Total Assets

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 2

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Question

Chapter 3, Problem 2P

a.

Summary Introduction

Adequate information:

Ratio Value Formula
Current Ratio 1.832716 Current AssetsCurrent Liabilities
Inventory Turnover 4.414239 Cost of Goods SoldAverage Inventory
A/R Turnover 8.333333 Net SalesAverage Accounts Receivable
Fixed Turnover 1.657982 Net SalesAverage Fixed Assets
LTD To Equity 0.843090 Long Term DebtEquity
Times Interest Earned 1.833333 Earnings Before Interest And TaxInterest
Net Profit Margin 0.016000 Net ProfitSales
Return On Total Assets 0.018061 Net Income Total Assets
Return On Equity 0.040307 Net IncomeEquity

To compute: Figures marked with ‘ratio’ in the financial statements.

a.

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Figure Calculated	Ratio Used for Calculation	Remark
Cost of Goods Sold	Inventory Turnover Ratio	Inventory value is given
Net Income	Return on Total Assets	Value of total asset is given
Equity	Return on Equity	Net income used to calculate
Long Term Debt	LTD To Equity	Equity value used
Sales	Net Profit Margin	Net profit used to find sales
Interest Expense	Times Interest Earned	Earnings before interest and tax used to calculate
Accounts Receivable	A/R Turnover	Sales figure already calculated
Net Plant and Equipment	Fixed Turnover	Sales figure used to find Average fixed assets and half of depreciation deducted to get closing value.

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 1

b)

Summary Introduction

To compute: Figures marked with ‘formula’ in the financial statements.

b)

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Formula to Be Calculated	Remark
Gross Profit	Sales − Cost Of Goods Sold
Earnings Before Interest and Tax	Gross Profit − Depreciation − Selling and Administration Expenses − Lease Expenses
Earnings Before Tax	Earnings Before Interest And Tax − Interest
Tax	Charged at 40 % of Earnings Before Tax
Total Current Assets	Cash + Accounts Receivable + Inventory
Accumulated Depreciation	Balancing Figure
Short Term Notes Payable	Balancing Figure
Total Liabilities and Owner’s Equity	Total Assets

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 2

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Question

Chapter 3, Problem 2P

a.

Summary Introduction

Adequate information:

Ratio Value Formula
Current Ratio 1.832716 Current AssetsCurrent Liabilities
Inventory Turnover 4.414239 Cost of Goods SoldAverage Inventory
A/R Turnover 8.333333 Net SalesAverage Accounts Receivable
Fixed Turnover 1.657982 Net SalesAverage Fixed Assets
LTD To Equity 0.843090 Long Term DebtEquity
Times Interest Earned 1.833333 Earnings Before Interest And TaxInterest
Net Profit Margin 0.016000 Net ProfitSales
Return On Total Assets 0.018061 Net Income Total Assets
Return On Equity 0.040307 Net IncomeEquity

To compute: Figures marked with ‘ratio’ in the financial statements.

a.

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Figure Calculated	Ratio Used for Calculation	Remark
Cost of Goods Sold	Inventory Turnover Ratio	Inventory value is given
Net Income	Return on Total Assets	Value of total asset is given
Equity	Return on Equity	Net income used to calculate
Long Term Debt	LTD To Equity	Equity value used
Sales	Net Profit Margin	Net profit used to find sales
Interest Expense	Times Interest Earned	Earnings before interest and tax used to calculate
Accounts Receivable	A/R Turnover	Sales figure already calculated
Net Plant and Equipment	Fixed Turnover	Sales figure used to find Average fixed assets and half of depreciation deducted to get closing value.

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 1

b)

Summary Introduction

To compute: Figures marked with ‘formula’ in the financial statements.

b)

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Formula to Be Calculated	Remark
Gross Profit	Sales − Cost Of Goods Sold
Earnings Before Interest and Tax	Gross Profit − Depreciation − Selling and Administration Expenses − Lease Expenses
Earnings Before Tax	Earnings Before Interest And Tax − Interest
Tax	Charged at 40 % of Earnings Before Tax
Total Current Assets	Cash + Accounts Receivable + Inventory
Accumulated Depreciation	Balancing Figure
Short Term Notes Payable	Balancing Figure
Total Liabilities and Owner’s Equity	Total Assets

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 2

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Chapter 3, Problem 2P

a.

Summary Introduction

Adequate information:

Ratio Value Formula
Current Ratio 1.832716 Current AssetsCurrent Liabilities
Inventory Turnover 4.414239 Cost of Goods SoldAverage Inventory
A/R Turnover 8.333333 Net SalesAverage Accounts Receivable
Fixed Turnover 1.657982 Net SalesAverage Fixed Assets
LTD To Equity 0.843090 Long Term DebtEquity
Times Interest Earned 1.833333 Earnings Before Interest And TaxInterest
Net Profit Margin 0.016000 Net ProfitSales
Return On Total Assets 0.018061 Net Income Total Assets
Return On Equity 0.040307 Net IncomeEquity

To compute: Figures marked with ‘ratio’ in the financial statements.

a.

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Figure Calculated	Ratio Used for Calculation	Remark
Cost of Goods Sold	Inventory Turnover Ratio	Inventory value is given
Net Income	Return on Total Assets	Value of total asset is given
Equity	Return on Equity	Net income used to calculate
Long Term Debt	LTD To Equity	Equity value used
Sales	Net Profit Margin	Net profit used to find sales
Interest Expense	Times Interest Earned	Earnings before interest and tax used to calculate
Accounts Receivable	A/R Turnover	Sales figure already calculated
Net Plant and Equipment	Fixed Turnover	Sales figure used to find Average fixed assets and half of depreciation deducted to get closing value.

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 1

b)

Summary Introduction

To compute: Figures marked with ‘formula’ in the financial statements.

b)

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Formula to Be Calculated	Remark
Gross Profit	Sales − Cost Of Goods Sold
Earnings Before Interest and Tax	Gross Profit − Depreciation − Selling and Administration Expenses − Lease Expenses
Earnings Before Tax	Earnings Before Interest And Tax − Interest
Tax	Charged at 40 % of Earnings Before Tax
Total Current Assets	Cash + Accounts Receivable + Inventory
Accumulated Depreciation	Balancing Figure
Short Term Notes Payable	Balancing Figure
Total Liabilities and Owner’s Equity	Total Assets

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 2

Answer 6

Chapter 3, Problem 2P

a.

Summary Introduction

Adequate information:

Ratio Value Formula
Current Ratio 1.832716 Current AssetsCurrent Liabilities
Inventory Turnover 4.414239 Cost of Goods SoldAverage Inventory
A/R Turnover 8.333333 Net SalesAverage Accounts Receivable
Fixed Turnover 1.657982 Net SalesAverage Fixed Assets
LTD To Equity 0.843090 Long Term DebtEquity
Times Interest Earned 1.833333 Earnings Before Interest And TaxInterest
Net Profit Margin 0.016000 Net ProfitSales
Return On Total Assets 0.018061 Net Income Total Assets
Return On Equity 0.040307 Net IncomeEquity

To compute: Figures marked with ‘ratio’ in the financial statements.

a.

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Figure Calculated	Ratio Used for Calculation	Remark
Cost of Goods Sold	Inventory Turnover Ratio	Inventory value is given
Net Income	Return on Total Assets	Value of total asset is given
Equity	Return on Equity	Net income used to calculate
Long Term Debt	LTD To Equity	Equity value used
Sales	Net Profit Margin	Net profit used to find sales
Interest Expense	Times Interest Earned	Earnings before interest and tax used to calculate
Accounts Receivable	A/R Turnover	Sales figure already calculated
Net Plant and Equipment	Fixed Turnover	Sales figure used to find Average fixed assets and half of depreciation deducted to get closing value.

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 1

Answer 7

Chapter 3, Problem 2P

a.

Summary Introduction

Adequate information:

Ratio Value Formula
Current Ratio 1.832716 Current AssetsCurrent Liabilities
Inventory Turnover 4.414239 Cost of Goods SoldAverage Inventory
A/R Turnover 8.333333 Net SalesAverage Accounts Receivable
Fixed Turnover 1.657982 Net SalesAverage Fixed Assets
LTD To Equity 0.843090 Long Term DebtEquity
Times Interest Earned 1.833333 Earnings Before Interest And TaxInterest
Net Profit Margin 0.016000 Net ProfitSales
Return On Total Assets 0.018061 Net Income Total Assets
Return On Equity 0.040307 Net IncomeEquity

To compute: Figures marked with ‘ratio’ in the financial statements.

Answer 8

a.

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Figure Calculated	Ratio Used for Calculation	Remark
Cost of Goods Sold	Inventory Turnover Ratio	Inventory value is given
Net Income	Return on Total Assets	Value of total asset is given
Equity	Return on Equity	Net income used to calculate
Long Term Debt	LTD To Equity	Equity value used
Sales	Net Profit Margin	Net profit used to find sales
Interest Expense	Times Interest Earned	Earnings before interest and tax used to calculate
Accounts Receivable	A/R Turnover	Sales figure already calculated
Net Plant and Equipment	Fixed Turnover	Sales figure used to find Average fixed assets and half of depreciation deducted to get closing value.

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 1

Answer 9

a.

Expert Solution

Answer 10

a.

Expert Solution

Answer 11

Expert Solution

Answer 12

b)

Summary Introduction

To compute: Figures marked with ‘formula’ in the financial statements.

b)

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Formula to Be Calculated	Remark
Gross Profit	Sales − Cost Of Goods Sold
Earnings Before Interest and Tax	Gross Profit − Depreciation − Selling and Administration Expenses − Lease Expenses
Earnings Before Tax	Earnings Before Interest And Tax − Interest
Tax	Charged at 40 % of Earnings Before Tax
Total Current Assets	Cash + Accounts Receivable + Inventory
Accumulated Depreciation	Balancing Figure
Short Term Notes Payable	Balancing Figure
Total Liabilities and Owner’s Equity	Total Assets

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 2

Answer 13

b)

Summary Introduction

To compute: Figures marked with ‘formula’ in the financial statements.

Answer 14

b)

Expert Solution

Explanation of Solution

Sequence of figures calculated and basis:

Formula to Be Calculated	Remark
Gross Profit	Sales − Cost Of Goods Sold
Earnings Before Interest and Tax	Gross Profit − Depreciation − Selling and Administration Expenses − Lease Expenses
Earnings Before Tax	Earnings Before Interest And Tax − Interest
Tax	Charged at 40 % of Earnings Before Tax
Total Current Assets	Cash + Accounts Receivable + Inventory
Accumulated Depreciation	Balancing Figure
Short Term Notes Payable	Balancing Figure
Total Liabilities and Owner’s Equity	Total Assets

EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 3, Problem 2P , additional homework tip 2

Answer 15

b)

Expert Solution

Answer 16

b)

Expert Solution

Answer 17

Expert Solution

Answer 18

Ch. 3 - Prob. 2P

Ratio	Value	Formula
Current Ratio	1.832716	Current AssetsCurrent Liabilities
Inventory Turnover	4.414239	Cost of Goods SoldAverage Inventory
A/R Turnover	8.333333	Net SalesAverage Accounts Receivable
Fixed Turnover	1.657982	Net SalesAverage Fixed Assets
LTD To Equity	0.843090	Long Term DebtEquity
Times Interest Earned	1.833333	Earnings Before Interest And TaxInterest
Net Profit Margin	0.016000	Net ProfitSales
Return On Total Assets	0.018061	Net Income Total Assets
Return On Equity	0.040307	Net IncomeEquity

Explanation of Solution

To compute: Figures marked with ‘formula’ in the financial statements.

Explanation of Solution

Want to see more full solutions like this?

Chapter 3 Solutions