PLEASE I NEED HELP WITH MY EXCEL ASSIGNMENT . IF YOU CAN INCLUDE ALL THE FORMULAS YOU USED TO KEY IN THE EXCELL SHEET I WILL REALLY APPRECIATE. THANKS

2)

B E F G H j K L M 1 2 3 Input Area House Cost Down Pmt APR Years Pmts Per Year D Calculations Monthly Pmt Loan Amount Periodic Rate No. of Pmts $ 600,000.00 $ 75,000.00 5.25% 25 12 4 5 6 7 8 Payment Number 1 Beginning Balance Monthly Payment Interest Paid Principal Paid Ending Balance You are required to use the appropriate PMT, IPMT and PPMT to complete the amortization table based on the information to the left. Anything contrary to foregoing instructions will result in zero marks. 20 marks 2 9 10 11 12 13 14 15 16 3 4 5 6 7 K L M N Bonus Bonus D Gender F F F M B 3 Last Name 4 Aikman 5 Fishe 6 Felser 7 Parsley 8 Leslie 9 9 Imber 10 Granger 11 Dunes 12 Cusak 13 Noble 14 Heatley 15 Bobbitt 16 Lobree 17 Sampieri 18 Crowder 19 Beamer F First Name Gary Bryan Cynthia Gwen Jean Cynthia Kevin Annette Barbara Linda Megan Oronzo Cindy Maylou Harold Laura E Title Account Rep Senior Account Rep Account Rep Manager Account Rep Senior Account Rep Trainee Senior Account Rep Account Rep Account Rep Senior Account Rep Account Rep Account Rep Account Rep Trainee Trainee M M F F M F F F G Salary Location $ 41,800 Detroit $ 51,300 Atlanta $ 40,900 Boston $ 74,200 Atlanta $ 48,500 Cleveland $ 48,500 Cleveland $ 20,500 Detroit $ 42,600 Cleveland $ 32,800 Cleveland $ 46,900 Boston $ 51,900 Cleveland $ 40,700 Cleveland $ 25,800 Cleveland $ 38,400 Cleveland $ 19,600 Phoenix $ 21,700 Boston Bonus is based on Gender and/or performance. 1. If the employee is Female (F), and the performance is Excellent the bonus is 5% of Salary. 2. If the performance is Excellent and obviously not female) the bonus is 3%. 3. If the performance is Good, 1% bonus, anything else is 0. H Performance Good Excellent Average Excellent Excellent Good Good Good Average Good Good Good Average Average Excellent Average You are required to use a logic statement to calculate the bonus. F M F M $ 20 Powell 21 Mills 22 Cole F F M 23 Foerster F M Kathy Wendy Kordell Shelly Crystal Betty Hank Emit Lorna Ashley Julianne F F F M 24 Cole 25 Guilford 26 Drubin 27 Wood 28 Spinale 29 Bryan 30 Posten 31 Watson 32 Pennekamp 33 Fegin 34 Everett 35 Erpf 36 White Account Rep Manager Account Rep Account Rep Trainee Account Rep Account Rep Senior Account Rep Account Rep Manager Trainee Account Rep Account Rep Account Rep Senior Account Rep Account Rep Account Rep 44,900 Chicago 70,900 Detroit 30,300 Miami 44,700 Kansas City 18,200 Cleveland 29,400 Cleveland 39,600 New York 59,100 Detroit 32,400 Kansas City 76,300 Cleveland 21,300 San Francisco 32,800 Chicago 33,700 New York 25,200 Boston 61,500 Atlanta 36,900 Boston 47.800 Miami $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ F Average Good Good Excellent Good Excellent Good Average Average Good Poor Good Average Excellent Good Excellent Average M Fran F F M Lynn Nancy Holly Meredith Jack F F F