For company Z, you have the financial statement (f.01) for the end of round 3 sh
ID: 2811994 • Letter: F
Question
For company Z, you have the financial statement (f.01) for the end of round 3 shown above.
Replicate Z’s ratios in the financial statement spreadsheet provided. Open the spreadsheet and move to the right. Don’t alter the column or row labels in the range of J1 to N25. Follow the example shown for the Gross Margin and describe the formula in words then show the numerator and denominator values. The ratio value will appear (replacing ‘#DIV/0’) when you enter the cell reference for the numerator and denominator values. Use cell reference “formulas” For example: Enter a cell reference such as =E28, do NOT type in the literal value, such as 21,238,784.1.
To figure out the formulas use a finance or accounting textbook or simple search on the Internet. Be sure to match exactly the ratios shown above, including values to the right of the decimal point. Use the minus sign or ABS() function, if needed, to make the ratio value shown.
J4 Thi s ratio. Financial Statements-ERPsim vancial Ratlo Ledg OL Numerator value Gro53 Marp Careecy type Company codecurnency Anounts in turogean Duro Reporting periads Corpardon perieds | 201701-2017 16 8 2016.01 201616 Net Margin Ths rato Retuen on Equity a Balance Sheet This radio 0 Current Assets Retam on Assets 0 Bank Cash Account 2853,776.96 2,853,77696 0 499 839.41 0 110,644.00 0189523.69 3,053.754.06 140000 Custoners-Domestk Recevables L0 aad00 Rawuterials LO 792000 Finished geeds 10 Total Current Assets 11 Long-Term Assits 11 001000 Land 1 002000 Buildings 11 002010 Accumulated Depreciution iing 11 011000 Machinery and equipment 11 011010 Accumulatad depreciation-achnary andim 1 Total LenTem Assests This rato 110,644.00 Debt to Equity DMO! 150000000 15,000.00 16,000,000.00 -39999996 17585,000.04 21.238.784.10 Moriketing to Sale 6,000 000.00 -399,999 96 7585 000.04 1,238.73410 Ths rato is in ERPso to highight how much money 8spent on maketng for each earo of evense generated Total 04sets G Labitles and Owrers Equity 2 Laia 4 Cuerent Liab es: 14 16000d Accounts payable-Domestk 4 Total Cuit Labiii 396.932 00 306,93200 396 932.00 0396,93200 396932.00 Tota Lab me 13 Equity L6 Shareholdes Equity G 070000 Comnon stack 6 Total Shaolde Equity 17 Retained Eaing 0 -20,000,000.00 0-20,000,00.0 20,00a.dco.o0 5 Add:Net Ihcome 7 Total Retained Earninga 13 Total tauty 541852.10 841852 10 20 941852 10 21,238784.10 0-841552.0 841852.10 Tota Libltis and Outers Equity 0 -21238,784.10Explanation / Answer
Financial Ratios Numerator/Denominator Numerator Value Denominator Value Ratio Gross Margin (Revenue-COGS)/Revenue 17,12,376.06 25,31,672.37 67.638 % This Ratio Gross Margin Ratio is a profitability ratio.Higher ratio is considered better.It is Calculated by dividing Gross Profit (sales- COGS) by Net Sales Net Margin Net Profit/Revenue 8,41,852.10 25,31,672.37 33.253 % This Ratio Higher the ratio ,higher the profitability .It is calculated by dividing Net Profit after tax by Net Sales The ratio alos indicates what portion of net sales is left for the owners after all expenses have been met. Return on Equity Net Profit/Shareholders Equity 8,41,852.10 2,08,41,852.10 4.039 % This Ratio It is a profitability ratio that measures companies ability to generate profit from money invested by shareholder It is calculated by dividing Net profit by Shareholders Fund Return on Assets Net Profit/Total Assets 8,41,852.10 2,12,38,784.10 3.964 % This Ratio This ratio shows how profitable companies assets are. It is calculated by dividing Net profit by Total Assets Debt to Equity Total Long term debts/Total Shareholders Equity - 2,08,41,852.10 - This Ratio Since there are no long term debts, debt equity ratio is zero which means company is entirely financed by owners funds as company has no debts.This ratio is also known as risk, leverage ratio. As higher the debts, higher the company risky Marketing to Sales Total Marketing Expense/Revenue 2,900.00 25,31,672.37 0.115 % This Ratio It is calculated by dividing Marketing EXpense by Net Sales
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.