logo

Mba 520 module two financial Statement Analysis Worksheet PDF

   

Added on  2021-04-21

12 Pages2269 Words132 Views
Running head: MBA 520 MODULE TWO FINANCIAL STATEMENT ANALYSIS WORKSHEETFinancial statement analysis worksheetName of the studentName of the UniversityAuthor noteWorksheet adapted from Brigham, E., & Houston, J. F. (2016). Fundamentals of financial management (14th ed.). Boston, MA: Cengage Learning.
Mba 520 module two financial Statement Analysis Worksheet PDF_1
1MBA 520 MODULE TWO FINANCIAL STATEMENT ANALYSIS WORKSHEETTable of ContentsAnswer 2:.........................................................................................................................................2Answer 3:.........................................................................................................................................4Answer 4:.........................................................................................................................................5Answer 5:.........................................................................................................................................6Answer 6:.........................................................................................................................................7Answer 7:.........................................................................................................................................9Answer 8:.......................................................................................................................................10Reference:......................................................................................................................................11Worksheet adapted from Brigham, E., & Houston, J. F. (2016). Fundamentals of financial management (14th ed.). Boston, MA: Cengage Learning.
Mba 520 module two financial Statement Analysis Worksheet PDF_2
2MBA 520 MODULE TWO FINANCIAL STATEMENT ANALYSIS WORKSHEET1. Calculate XYZ’s 2013 current and quick ratios based on the projected balance sheet andincome statement data. Answer 1:Current ratio is calculated through dividing the current assets with current liabilities. Accordingto the given information current ratio is as follows:(Total Current Assets ÷ Total Current Liabilities)($2,680,112÷$1,114,800) = 2.4Therefore, Current Ratio of XYZ of 2013 is 2.4Quick ratio is calculated through dividing the quick assets with current liabilities. Consideringthe given data, quick ratio is as follows:[(Total Current Assets – Inventories) ÷ (Total Current Liabilities)]= [($2,680,112 - $1,716,480) ÷ ($1,114,800)]= [$963,632 ÷ $1,114,800]= .86Therefore, quick ratio of XYZ of 2013 is .862. Calculate the 2013 inventory turnover, days sales outstanding (DSO), fixed assets turnover,and total assets turnover. Answer 2:Inventory Turnover Ratio is calculated through dividing the Cost of Goods sold with the AverageInventory. Considering the given data, Inventory Turnover Ratio of 2013 of XYZ is as follow:Cost of Goods Sold in 2013 ÷ Average Inventory= [Cost of Goods Sold in 2013 ÷ {(Inventories of 2013 + Inventories of 2012) ÷ 2}]Worksheet adapted from Brigham, E., & Houston, J. F. (2016). Fundamentals of financial management (14th ed.). Boston, MA: Cengage Learning.
Mba 520 module two financial Statement Analysis Worksheet PDF_3
3MBA 520 MODULE TWO FINANCIAL STATEMENT ANALYSIS WORKSHEET= [$5,875,992 ÷ {($1,716,480 + $1,287,360) ÷ 2}]= $5,875,992 ÷ $1,501,920= 3.91Therefore, Inventory Turnover Ratio is 3.91Days Sales Outstanding is calculated through dividing the Account Receivable with the sales ofone year, multiplied with 365. Considering the given data Days Sales Outstanding is as follows:Accounts receivable ÷ (sales x 365)= $878,000 ÷ ($7,035,600 x 365)= 45.55 Therefore, Days Sales Outstanding of XYZ is 45.55 days. Fixed Assets Turnover is calculated through dividing the Sales value with the Average Net FixedAssets. Taking the given data into consideration, Fixed Assets Turnover is as follow:Sales of 2013 ÷ Average Net Fixed Assets= [Sales of 2013 ÷ {(Net Fixed Assets of 2013 + Net Fixed Assets of 2012) ÷ 2}]= [$7,035,600 ÷ ($817,040 + $939,790) ÷ 2]= $7,035,600 ÷ 878,415= 8.01Therefore, Fixed Assets Turnover is 8.01for XYZ during 2013.Total Assets Turnover is calculated through dividing the total sales with the Average Total FixedAssets. Considering the given financial statement, Total Assets Turnover of the firm of 2013 isas follows:Sales of 2013 ÷ Average Net Fixed Assets= [Sales of 2013 ÷ {(Total Assets of 2013 + Total Assets of 2012) ÷ 2}]Worksheet adapted from Brigham, E., & Houston, J. F. (2016). Fundamentals of financial management (14th ed.). Boston, MA: Cengage Learning.
Mba 520 module two financial Statement Analysis Worksheet PDF_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
7702AFE: Accounting and Reporting
|14
|2476
|22

Accounting Integrated Reporting
|14
|2573
|305

Ratio Analysis Of Argil | Report
|4
|944
|631

Financial Analysis: Evaluating the Financial Position of a Company
|9
|2257
|94

Integrated Reporting: Accounting Name of the University Student ID
|11
|2424
|416

FINANCE 5 FINANCE Finance Name of the university Student ID
|6
|542
|479