ACCT 212 Assignment Analysis and Excel Simulation solutions complete answers

ACCT 212 Assignment Analysis and Excel Simulation solutions complete answers 

Just put your values given and automatically provide answers for you!

Question

Use Apple's financial statements in Appendix A to answer the following.

1. Using fiscal 2017 as the base year, compute trend percents for fiscal years 2017, 2018, and 2019 for total net sales, total cost of sales, operating income, other income (expense) net, provision for income taxes, and net income.

2. Compute common-size percents for fiscal years 2018 and 2019 for the following categories of assets: (a) total current assets; (b) property, plant and equipment, net; and (c) accounts receivable, net.

3. Using current assets as a percent of total assets to measure liquidity, did Apple's asset makeup become more liquid or less liquid in 2019?

 

Question

Key figures for Apple and Google follow.

1. Compute common-size percents for each company using the data given.

2. If Google paid a dividend, would retained earnings as a percent of total assets increase or decrease?

3. Which company has the better gross margin ratio on sales?

If Google paid a dividend, would retained earnings as a percent of total assets increase or decrease?

Which company has the better gross margin ratio on sales?

 

Question

Key figures for Samsung follow (in $ millions).

1. Compute common-size percents for Samsung using the data given.

2. What is Samsung's gross margin ratio on sales?

3. Does Samsung's gross margin ratio outperform or underperform the industry average of 25%?

What is Samsung's gross margin ratio on sales?

Does Samsung's gross margin ratio outperform or underperform the industry average of 25%?

 

Question

1. Compute and interpret financial ratios that managers use to assess liquidity.

2. Compute and interpret financial ratios that managers use for asset management purposes.

3. Compute and interpret financial ratios that managers use for debt management purposes.

Recent financial statements for Zimmer, Inc. are as follows:

Compute the following ratios for the current year only

 

Question

1. Use ratios to analyze a company's liquidity and solvency.

Condensed financial statements for Games Galore are summarized below:

Compute the following liquidity ratios for 2016. Round to the required number of decimal places USING THE EXCEL. ROUND FUCTION (fx).

Compute the following solvency ratios for 2016. Again, USE THE EXCEL ROUND FUCTION (fx).

Compute the following Profitability ratios for 2016. Again, USE THE EXCEL ROUND FUCTION (fx).

 

Question

1. Use vertical analysis to compare profitability.

Lake Athletics sells two distinct product lines: Apparel and Equipment.

The income statement for each product line appears below.

1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns for both product lines above. Express each amount as a percentage of net sales.

Note: You should use absolute references in the divisors of all formulas.

2. Use the Excel IF function and the completed vertical analysis above to answer each of the questions below:

 

Question

1. Determine the break-even point.

2. Compute the margin of safety and explain its significance.

3. Compute the degree of operating leverage at a particular level of sales and explain how it can be used to predict changes in net operating income.

Given the following information complete a CVP analysis for JPL, Inc.:

1. Compute the CM ratio and variable expense ratio

2. Compute the break-even point

3. Compute the margin of safety

4. Compute the degree of operating leverage

 

Question

1. Prepare a sales budget, including a schedule of expected cash collections.

2. Prepare a direct materials budget, including a schedule of expected cash disbursements for purchases of materials.

3. Prepare a cash budget.

S & P Enterprises needs a cash budget for March. The following information is available.

The company has a line of credit available to bolster the cash balance as needed.

Click the Schedules and Cash Budget tab to prepare the following:

1. Schedule of expected cash collections for March.

2. Schedule of expected cash disbursements for inventory purchases for March.

3. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that any interest will not be paid until the following month.

 

Question

Prepare a make or buy analysis.

Alanco, Inc. manufactures a variety of products and is currently manufacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following information has been gathered relating to the cost of producing the component internally:

Assuming the company has no alternative use for the facilities now being used to produce the component, complete the following analysis to determine if the outside supplier's offer should be accepted.

Based on this analysis, write an if statement to determine if Alanco should make or buy the component.