In completing Excel Lab 1, I learned [Set up set how to set up the spreadsheet...

Transcribed Image Text:

In completing Excel Lab 1, I learned [Set up set how to set up the spreadsheet on excel which was very new to me ]. I applied these skills in Managerial Accounting by creating a Ratio Analysis spreadsheet. Ratios are computed by dividing one element on a spreadsheet by another. Safety Ratios, for instance, measure how safe a company is from going bankrupt. They compare what a company owes, its liabilities, to what it owns, its assets. In looking at the Current Ratio on the Safety spreadsheet, I noticed that Natalie's company has about [$1.50] in assets for every dollar that they owe. [In looking at the Current Ratio on the Safety spreadsheet, I noticed that Lucy's company has about [$ 50] in assets for every dollar that they owe.] When we look at the acid test ratio, which factors out Inventory, I see that [finish the sentences for the three companies] The issue is that Geralyn's company [your answer] If I had to lend money to one of these companies, I would most likely lent it to [which company?] because [why?]. Finance managers and executives need to be concerned about their company's safety ratios because companies with good ratios [explain the effect of a good safety ratio on the ability to borrow money] In looking at the productivity of these three companies, I determined that the most productive company is run by [name] because every dollar of assets generates [amount] in sales. The least productive company is run by [name] because he gets to keep only [amount] of every dollar that he earns in sales. Focus In completing Excel Lab 1, I learned [Set up set how to set up the spreadsheet on excel which was very new to me ]. I applied these skills in Managerial Accounting by creating a Ratio Analysis spreadsheet. Ratios are computed by dividing one element on a spreadsheet by another. Safety Ratios, for instance, measure how safe a company is from going bankrupt. They compare what a company owes, its liabilities, to what it owns, its assets. In looking at the Current Ratio on the Safety spreadsheet, I noticed that Natalie's company has about [$1.50] in assets for every dollar that they owe. [In looking at the Current Ratio on the Safety spreadsheet, I noticed that Lucy's company has about [$ 50] in assets for every dollar that they owe.] When we look at the acid test ratio, which factors out Inventory, I see that [finish the sentences for the three companies] The issue is that Geralyn's company [your answer] If I had to lend money to one of these companies, I would most likely lent it to [which company?] because [why?]. Finance managers and executives need to be concerned about their company's safety ratios because companies with good ratios [explain the effect of a good safety ratio on the ability to borrow money] In looking at the productivity of these three companies, I determined that the most productive company is run by [name] because every dollar of assets generates [amount] in sales. The least productive company is run by [name] because he gets to keep only [amount] of every dollar that he earns in sales. Focus