MS Excel: Sales Worksheet
Start with a new spreadsheet in Microsoft Excel online or installed version of Microsoft Excel with no template applied. A template is not allowed for assignment.
NOTE: You will not need to use files from the textbook for the assignment
Sales Summary Worksheet
Problem: You have been asked to build a worksheet for International Moving Company that analyzes the financing needs for the company’s first year in business. The company plans to begin operations in January with an initial investment of $750,000.00. The expected revenue and costs for the company’s first year are shown in Table 2–7. The desired worksheet is shown in Figure 2–73. The initial investment is shown as the starting balance for January (cell B4). The amount of financing required by the company is shown as the lowest ending balance (cell F18).