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 tle comp any's first year in business. The company plans to begin operations in January with an initial investment of $ The expected revenue and costs for the company's first year are shown in Table The desired worksheet is shown in Figure The initial investment is shown as the starting balance for January cell BThe amount of financing required by the company is shown as the lowest ending balance cell F Table International Moving Company Financing Needs Data Month Incomes Expenses January February March April May June July August September October November December Perform the following tasks: Apply the Slate theme to a new workbook. Increase the width of column A to and the width of columns B through F to Enter the worksheet title International Moving Company in cell Al and the worksheet subtitle Financing Needs in cell A Enter the column titles in row as shown in Figure In row use ALTENTER to start a new line in a cell Enter the financing needs data described in Table in columns A C and D in rows through Enter the initial starting balance cell B of Enter the row titles in the range Al:Al as shown in Figure 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. 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 E and copy it to the range E:E 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 F and copy it to the range F:FIn the range B:B use the AVERAGE, MAX, and MIN functions to determine the average value, highest value, and lowest value in tle range B:B Copy the range B:B to the range C:FOne at a time, merge and center the worksheet title and subtitle across columns A through F Select cells A and A and change the background color to Tan, Accent from the theme colors column row Apply the Title cell style to cells Al and A Change the worksheet title in cell Al to point. Bold both the title and subtitle. Draw a thick outside border around the range A:ACenter the titles in row columns A through F Apply the Heading cell style to the range A:F Italicize and hold the row titles in the range A:ADraw a thick outside border around the range A:F Change the background color for cell F to the same colors applied to the worksheet title in Step Change the row heights of row to points and row to points. Assign the accounting number format to the range B:F Assign the comma style format to the range B:F Assign a currency format with a floating dollar sign to the range B:FRename the sheet tab as Financing Needs. Apply the Orange color from the standard colors column to the sheet tab. 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
