Practice: Basic Calculations

On the Toolbar, click the icon to open a new workbook.

Enter the following data:

A 
B 
C 
D 
E 
F 
G 
1 
Buying an HDTV 






2 







3 
Dream Television 
LCD 
Plasma 
Total 
Diff 
Avg 
Max 
4 
Price 
4000 
17000 




4 
Payments 
36 
24 




4 
Interest Rate 
.11 
.12 




7 
Finance Chg 






8 
Amt Financed 






9 
Est Monthly Pmt 







In cell D4, calculate the total price of both televisions together.

In cell D5, calculate the total payments made for both televisions.

In cell E4, calculate the difference in price between the two televisions.

In cell E5, calculate the difference between the number of payments.

In cell B7, calculate the finance charge for the LCD television.
TIP: Multiply its price by the interest rate.

In cell B8, calculate the amount financed.
TIP: Add the price and the finance charge.