(chow, Alexander) Assignment 4b

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View (chow, Alexander) Assignment 4b as PDF for free.

More details

  • Words: 527
  • Pages: 5
5 CustID fName 4 Michael 9 Bob 4 Lisa 2 Robin 3 Susan 1 Salvatore 2 Bill 5 Maria 7 Martha 8 Luis 4 Matt

Iname Nelson Metz Harris Spencers Ryland Wallace Dodd Duran Fried Lopez Day

Excel Assignment 4b (Advanced Functions) OrderID ProductName Quantity UnitPrice Total 19283c Dimension 2300 2 $649.00 $1,298.00 23404p Canon Multipass 3 $399.00 $1,197.00 16784c Inspiron 8200 1 $1,300.00 $1,300.00 17340c Latitude x200 1 $1,699.00 $1,699.00 19284c Dimension 2300 4 $649.00 $2,596.00 17341c Latitude x200 3 $1,699.00 $5,097.00 15434c Inspiron 2650 3 $899.00 $2,697.00 0232m Comfort Carry 20 $79.00 $1,580.00 0543m Kenneth Cole 5 $249.00 $1,245.00 50872n Logitech Wireless 15 $70.00 $1,050.00 23410p Canon ZR45MC 5 $799.00 $3,995.00

Alexander Chow 11/26/07 Software App. A Pd. 7

Alexander Chow 11/26/07 Software App. A Pd.7

5

fName Michael Bob Lisa Robin Susan Salvatore Bill Maria Martha Luis Matt Rate

Iname Nelson Metz Harris Spencers Ryland Wallace Dodd Duran Fried Lopez Day 8.00%

Excel Assignment 4b (Advanced Functions) Term in Years – Monthly Payment Principal 1 2 3 4 $1,298.00 $112.91 $58.71 $40.67 $31.69 $1,197.00 $104.13 $54.14 $37.51 $29.22 $1,300.00 $113.08 $58.80 $40.74 $31.74 $1,699.00 $147.79 $76.84 $53.24 $41.48 $2,596.00 $225.82 $117.41 $81.35 $63.38 $5,097.00 $443.38 $230.52 $159.72 $124.43 $2,697.00 $234.61 $121.98 $84.51 $65.84 $1,580.00 $137.44 $71.46 $49.51 $38.57 $1,245.00 $108.30 $56.31 $39.01 $30.39 $1,050.00 $91.34 $47.49 $32.90 $25.63 $3,995.00 $347.52 $180.68 $125.19 $97.53

5 $26.32 $24.27 $26.36 $34.45 $52.64 $103.35 $54.69 $32.04 $25.24 $21.29 $81.00

5 Excel Assignment 4b (Advanced Functions) Term in Years – Total Interest Paid fName Iname Principal 1 2 3 4 5 Michael Nelson $1,298.00 $56.93 $110.92 $166.29 $223.02 $281.13 Bob Metz $1,197.00 $52.50 $102.29 $153.35 $205.67 $259.25 Lisa Harris $1,300.00 $57.02 $111.09 $166.54 $223.37 $281.56 Robin Spencers $1,699.00 $74.52 $145.19 $217.66 $291.92 $367.98 Susan Ryland $2,596.00 $113.86 $221.84 $332.57 $446.05 $562.25 Salvatore Wallace $5,097.00 $223.56 $435.56 $652.97 $875.77 $1,103.93 Bill Dodd $2,697.00 $118.29 $230.47 $345.51 $463.40 $584.13 Maria Duran $1,580.00 $69.30 $135.02 $202.41 $271.48 $342.20 Martha Fried $1,245.00 $54.61 $106.39 $159.50 $213.92 $269.65 Luis Lopez $1,050.00 $46.05 $89.73 $134.51 $180.41 $227.41 Matt Day $3,995.00 $175.23 $341.39 $511.80 $686.42 $865.25 Rate

8.00%

Alexander Chow 11/28/07 Software App. A Pd. 7

Alexander Chow 11/28/07 Software App. A Pd. 7

5 Excel Assignment 4b (Advanced Functions) fName Michael Bob Lisa Robin Susan Salvatore Bill Maria Martha Luis Matt

Iname Principal Nelson $1,298.00 Metz $1,197.00 Harris $1,300.00 Spencers $1,699.00 Ryland $2,596.00 Wallace $5,097.00 Dodd $2,697.00 Duran $1,580.00 Fried $1,245.00 Lopez $1,050.00 Day $3,995.00 WINNER: LOSER:

Die1

Die2 5 5 2 5 2 3 6 3 1 1 3 0 11

Die3 3 2 2 3 2 2 4 2 5 4 4

Check 5 LOSER 5 LOSER 1 LOSER 6 LOSER 6 LOSER 4 LOSER 5 LOSER 2 LOSER 5 LOSER 5 LOSER 3 LOSER

5 Excel Assignment 4b (Advanced Functions) fName Iname Principal Rating Michael Nelson $1,298.00 Bronze Bob Metz $1,197.00 Bronze Lisa Harris $1,300.00 Bronze Robin Spencers $1,699.00 Bronze Susan Ryland $2,596.00 Silver Salvatore Wallace $5,097.00 Gold Bill Dodd $2,697.00 Silver Maria Duran $1,580.00 Bronze Martha Fried $1,245.00 Bronze Luis Lopez $1,050.00 Bronze Matt Day $3,995.00 Gold 1000 Bronze 2000 Silver 3000 Gold

Alexander Chow 11/28/07 Software App. A Pd. 7

Related Documents