Question: Problem: You have been asked to build a worksheet for International Moving Company that analyzes the financing needs for tl 1 e comp any's first

Problem: You have been asked to build a worksheet for International Moving Company that analyzes the financing needs for tl1e comp any'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 1. 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 1 International Moving Company Financing Needs Data Month Incomes Expenses January 12090811262911 February 11638111381881 March 13006601250143 April 12292071209498 May 12483691355232 June 11961181260888 July 11629701242599 August 11958241368955 September 13056691235604 October 12247411383254 November 11596441411768 December 12100001540000 Perform the following tasks: 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 Al and the worksheet subtitle Financing Needs in cell A2. Enter the column titles in row 3, as shown in Figure 1. In row 3, use ALT+ENTER to start a new line in a cell 4.Enter the financing needs data described in Table 1 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 Al6:Al8, as shown in Figure 1.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:B18, use the AVERAGE, MAX, and MIN functions to determine the average value, highest value, and lowest value in tl1e range B4:B15. Copy the range B16:B18 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 Al and A2. Change the worksheet title in cell Al 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 hold the row titles in the range A16:A18.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:F4. 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, course number, and other information as specified by your instructor.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!