F. Given the Information below, answer each question in thegrayed space provided. Question 3.1 Find the monthly car payment given the information below. 2 marks (hint payme $32 000.00 Rebate $2,000.00 Gas credit 2% of purchase price Down payment 10% of purchase price $5 000.00 Amount to finance 9 00% Terms (years)K17 A B F G H 3.2 Find the Best Purchase price given the information in Question 3.1 2 marks (hint: goal seek) Rebate Down Payment Amount to finance Interest Terms (years) $450 00(17 XVAx A B C E G K M 3.3 Winter Life Sports Wear Manufacturing manufacturers a complete line of sportswear. The marketing manager has been asked to produce a 5 year forcast on a new product- battery operated thermal socks. The manager has been asked to prepare and show 3 different projections or scenarios using the data assumptions provided below. Complete the following exercise and produce a web page to show one (1) business case. Pay attention to accuracy and formatting . 10 marks BONUS Show an example of data validation and a comment in your work 6 marks (hint: scenario manager) Winter Life Sports Manufacturing Income Revenues Year Units Sold Unit Price Gross Revenue Expenses Fixed Costs Production facility Administration Variable cost Unit mig cost Variable mio most Formula Calculations + eady To Accessibility, UnavailableA B G H 47 48 Expenses Fixed Costs 49 Production Facility 50 Administration 51 52 Variable cost 53 Unit mig cost 54 Variable mig cost 55 Utilities 56 57 Earnings before taxes 58 59 60 Assumptions Initial Values Consensus Pessimistic Optimistic 61 Increase Increase Increase 62 63 First year sales (units 120000 0 1 0.05 0.2 Selling price 10 00 0 05 0 01 01 65 Unit mig cost 5 00 01 0 05 0 15 Production facility $ 60 090 00 0 08 0 05 Utilities 5 30 000 00 0 01 0 009 0.012 Administration $ 32 000.90 0:05 0 02 0 09 First year of forecas 2016 Formula Calculations leady Accessibility. Unavailable