Focus 99 35% 10% 1421 5 12 (225) s (2,204) TRUE CONSIDER 1730 Windstar 17999 12.
ID: 3831226 • Letter: F
Question
Focus 99 35% 10% 1421 5 12 (225) s (2,204) TRUE CONSIDER 1730 Windstar 17999 12.5% Mustang 6.223 0% 15,045 4.6 123 320 CONSIDER Can you urchase Ford Taurus LEALSE Above is a spreadsheet analyzing several possible car purchasing/financing options. Values in the un-highlighted cells are given, values in shaded cells contain the formulas you will write, and values in cells with a pattern are copied from the formulas you will write. For each of the different car promotions, you will be asked to calculate either the loan payment, lling price, loan duration, interest rate or balloon payment. A balloon payment is an amoun still owe on the loan at the end of the loan duration (future value). If a loan is fully paid off at the end of the loan duration it has no balloon payment (FV-0. The number of compounding periods per year is given in column G Please note when writing formulas, to receive ful credit you must use correct Excel syntax (ie:use for multiplication, for division, etc.). Do not use unnecessary S or functions. Also note, when writing your ormulas, use cell references whenever ssible. 1. (1 point) In cell E5, write an Excel formula which can be copied down the column into cells E6:E8 to show the actual loan amount round to nearest dollar. The loan amount is what you need to borrow from the bank after you have paid the specified down payment. 2. (1 point) The Ford Taurus promotion is as follows: S22,300 sticker price with 4.8% financing for 5 years. A down payment of 5% is required. Write an Excel formula in cell H5 to determine the monthly payment on this loan 3. (1 point) You always wanted to own a Thunderbird. There are no special promotions at the current time. The dealer has told you that the sticker price is S24,300 and a 20% down payment is required for the standard Ford loan with 6.8% annual interest. The loan requires you to pa $259 per month. Write an Excel formula in cell F6 to determine how many years it will take to pay off this loan. 4. (1 point) The Ford Focus seems like the most reasonably priced car on the lot. The car sells for $15,799. A special promotional financing is available where you pay 10% up front and onl $225 per month (at the end of each month). The annual interest rate is 3.5 interest CSE 1111 Hw5B doc.Explanation / Answer
Hi,
In the limited time constrain I can't answer all your questions. And also according to Chegg we have to answer one question at a time. So I am answering the first question you asked in the diagram.
1 ) =ROUNDUP(SUM(E6:E8),0)
The above formula will give you answer to the naerest Dollar i.e. it will roundup to the nearest integer value.