Your supervisor in the finance department at August Online Technology has asked you to create a worksheet
Question:
Your supervisor in the finance department at August Online Technology has asked you to create a worksheet for the flagship product that will project the annual gross margin, total expenses, operating income, income taxes, and net income for the next eight years based on the assumptions in Table 3- 9. The desired result is shown in Figure 3-85. You will place these assumptions in the spreadsheet (see step 8), as shown in Fig. 3-85 and use them with absolute references when building your formulas. Some steps have *’s in front of them. The *’s indicate that this is where you will print something, one print per *. Definitions: workbook: the entire spreadsheet file, worksheet: one of possibly many tabs (spreadsheets or charts) in the file. Be sure to include the lab “Part number” with the step number in the footer.
Excel Module 3 Working with Large Worksheets, Charting, and What-If Analysis
Figure 3-85
Instructions Part 1:
Run Excel, open a blank workbook, and create the worksheet following these instructions. Do NOT use “fit to one page” EVER! Do NOT print double-sided! It is OK if it takes multiple pages. Just be sure to label them with the same step number in the footer. When entering numbers, do NOT use the Comma icon and do NOT type the commas. When typing currency, do NOT type the $-signs or commas. You will be told how to format them!
10. Complete the following sub-steps (a-s). Remember to use absolute references for the percentages (these are called “constants”) in the formulas. You are NOT permitted to use named references for them. Put these constants below the assumptions. You do NOT have to create labels for them. The instructions below give you: the name of a cell = formula. For example: Year 2 Sales (cell C4) = formula. You only need to type the = and the formula that follows it, into the cell.
Excel Module 3 Working with Large Worksheets, Charting, and What-If Analysis
income of $1,500,000. See the instructions in the book for doing a goal seek operation. Save the workbook with your needed changes with the new name “Lab 3-1 GS” (without the quotes, of course). Print the saved worksheet with these new values.
3. How would you use what-if analysis tools to determine what Annual Sales Growth you would need to achieve in order to keep prices steady over the eight-year projection period?
Introduction to Financial Accounting
ISBN: 978-0133251036
11th edition
Authors: Charles Horngren, Gary Sundem, John Elliott, Donna Philbrick