Excel Problem

4 In cells B8:H16, create a Data Table using the information in cells B2:B4 where the row input cell is the Period and the column input cell is the Rate. Apply the format in B8 to the results in the data table, and then AutoFit columns C:H. Format the payment option closest to and less than $8,000 per month with the Note cell style. Change the Orientation to Landscape. le Dota Heview View Developer Help Share Comments OX Wapet Home insert DrawPage Layout Form -AA - BIU Stomato FE Di 3% Condu Fom we Son De H M N b R 5 G Loan Options for Idaho Store Purchase: Rates versus Months 2 Amoont of 550.000 3 Period (month) 120 4 Interest rate real 5.PN Payment Options Number of Monthly Payments $19,480 120 180 200 100 09 360 ---BARAN 3.00 7. 7.00 6.SON 600N NOS 17 19 Projected Income Statement Model 2 3 11 21 Sales $ 125,000 $187.500 $152.250 $116.875 $183,033 $201.314 $221,445 $241.890 $262.949 $294.143 $324.238 5356,640 23 Expenses 24 Costs related sales 1000 144,745 150,221 175.143 19245 211,90 233,115 256,427 282,064 110.220 25 Corts to 10.000 200 40.000 40.000 60.000 40.000 0.000 40.000 40.000 10000 40.000 Total Expense 14.50 1595 1715 164,46 199,231 215143 212652 251.03 22 ANT 27 122,069 Idaho Store Quarterly Apparel Costs Product information Phone Order Sder Attendance Expenseeport Winter Programov SEVES STEE 9 000 NOSE