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). Table 2-7 International Moving Company Financing Needs Data Month January February March April May June July August September October November December 2015 Cengage Learning Incomes 1209081 1163811 1300660 1229207 1248369 1196118 1162970 1195824 1305669 1224741 1159644 1210000 Expenses 1262911 1381881 1250143 1209498 1355232 1260888 1242599 1368955 1235604 1383254 1411768 1540000 B A B E F International Moving Company 2 Financing Needs Starting Ending 3 Month Balance Incomes Expenses Net Balance 4 January $ 750,000.00 $ 1,209,081.00 $ 1,262,911.00 $ (53,830.00) $ 696,170.00 5 February 696,170.00 1,163,811.00 1,381,881.00 (218,070.00) 478,100.00 6 March 478,100.00 1,300,660.00 1,250,143.00 50,517.00 528,617.00 7 April 528,617.00 1,229,207.00 1,209,498.00 19,709.00 548,326.00 8 May 548,326.00 1,248,369.00 1,355,232.00 (106,863.00) 441,463.00 9 June 441,463.00 1,196,118.00 1,260,888.00 (64,770.00) 376,693.00 10 July 376,693.00 1,162,970.00 1,242,599.00 (79,629.00) 297,064.00 11 August 297,064.00 1,195,824.00 1,368,955.00 (173,131.00) 123,933.00 12 September 123,933.00 1,305,669.00 1,235,604.00 70,065.00 193,998.00 13 October 193,998.00 1,224,741.00 1,383,254.00 (158,513.00) 35,485.00 14 November 35,485.00 1,159,644.00 1,411,768.00 (252,124.00) (216,639.00) 15 December (216,639.00) 1,210,000.00 1,540,000.00 (330,000.00 (546,639.00) 16 Average 17 Highest 18 Lowest 19 $354,434.17 $1,217,174.50 $1,325,227.75 $750,000.00 $1,305,669.00 $1,540,000.00 -$216,639.00 $1,159,644.00 $1,209,498.00 -$108,053.25 $70,065.00 -$330,000.00 $246,380.92 $696,170.00 -$546,639.00 1. Apply the Slate theme to a new workbook. 2. Increase the width of column A to 12.00 and the width of columns B through F to 14.50. 3. Enter the worksheet title International Moving Company in cell A1 and the worksheet subtitle Financing Needs in cell A2. Enter the column titles in row 3, as shown in Figure 2-73. In row 3, use alt+enter to start a new line in a cell. 4. Enter the financing needs data described in Table 2-7 in columns A, C, and D in rows 4 through 15. Enter the initial starting balance (cell B4) of 750000.00. Enter the row titles in the range A16:418, as shown in Figure 2-73. 5. For the months of February through December, the starting balance is equal to the previous month's ending balance. Obtain the starting balance for February by setting the starting balance of February to the ending balance of January. Use a cell reference rather than typing in the data. Copy the formula for February to the remaining months. 6. Obtain the net amounts in column E by subtracting the expenses in column D from the incomes in column C. Enter the formula in cell E4 and copy it to the range E5:E15. Obtain the ending balance amounts in column F by adding the starting balance in column B to the net in column E. Enter the formula in cell F4 and copy it to the range F5:F15. 7. In the range B16:118, use the AVERAGE, MAX, and MIN functions to determine the average value, highest value, and lowest value in the range B4:815. Copy the range B16:518 to the range C16:F18. 8. One at a time, merge and center the worksheet title and subtitle across columns A through F. Select cells A1 and A2 and change the background color to Tan, Accent 2 from the theme colors (column 6, row 1). Apply the Title cell style to cells A1 and A2. Change the worksheet title in cell A1 to 26-point. Bold both the title and subtitle. Draw a thick outside border around the range C16:F18. 8. One at a time, merge and center the worksheet title and subtitle across columns A through F. Select cells A1 and A2 and change the background color to Tan, Accent 2 from the theme colors (column 6, row 1). Apply the Title cell style to cells A1 and A2. Change the worksheet title in cell A1 to 26-point. Bold both the title and subtitle. Draw a thick outside border around the range A1:A2. 9. Center the titles in row 3, columns A through F. Apply the Heading 2 cell style to the range A3:F3. Italicize and bold the row titles in the range A16:418. 10. Draw a thick outside border around the range A16:F18. Change the background color for cell F18 to the same colors applied to the worksheet title in Step 8. 11. Change the row heights of row 3 to 42.00 points and row 16 to 33.00 points. 12. Assign the accounting number format to the range B4:54. Assign the comma style format to the range B5:F15. Assign a currency format with a floating dollar sign to the range B16:F18. 13. Rename the sheet tab as Financing Needs. Apply the Orange color from the standard colors (column 3) to the sheet tab. 14. Change the worksheet header with your name and course number. 15. Display the formulas version by pressing CTRL+accent mark (). Change the Orientation to Landscape. 16. Save the workbook using the file name, Assign2.xlsx. Turn in the assignment in Canvas