Question: Do the following for GOOGLE Generate the projected income statement and balance sheet for the upcoming year using the data collected previously. 1. Apply Excel

Do the following for GOOGLE

Generate the projected income statement and balance sheet for the upcoming year using the data collected previously.

1. Apply Excel linear regression to estimate its sales using time as the independent variable. Report regression result. Derive estimated sales.

2. Use percentage of sales method to generate projected income statement. Analyze the expenses and the profits.

3. Use percentage of sales method to generate projected balance sheet. Analyze the assets, liabilities and equity.

DATA COLLECTED PREVIOUSLY;

Step by Step Solution