Professional Memo



4310 MemorandumTo:4310 StudentsFrom:Gary G. BergDate: TIME \@ "MMMM d, yyyy" October 26, 2017Re:Assignment 4 Download the excel files for this assignment on the class web site.The excel file for this assignment allows the user to compute current mortgage/car payment and prepare a loan amortization schedule (no warm fuzzy for this assignment)I have reference material on class web site for Excel 2007, 2010 & 2013 that worksheet protection and restricting cell access. You must use Excel 2007 or later.Enter the following data into the yellow highlighted cellsCurrent LoanLoan amount$20,000Term(years)3Interest Rate4.5%Payments per year 120 = ordinary annuity, 1 = annuity dueRequiredYou will need to use the payment function where indicated to calculate the mortgage/car paymentsCorrect payment should be calculated based on the type of annuity code (0 or 1) entered in cell D9Complete the amortization schedule. (They will be different. Up to you to figure it out)Do not hard code any formulas/functions. Use cell references in all formulas/functions in the output areaIf I change any of the input parameters (rate, # payments per year, term, etc.), the new payment and revised amortization schedule should be calculated automaticallyHard coding any formulas/functions will result in grade of ZERO on this assignment grade.Protect the worksheet by limiting users to the ability to select and enter data only in the yellow highlighted cells. (Use password acct4310). Password is case sensitive.Worksheet protection preventing data input entry (requiring password entry before data input) will result in a grade of ZERO. Make sure you enter your name in the highlighted cell. Failure to enter your name will result in grade of ZEROThis assignment is not a group project. Students should work independently. Copying/plagiarism will result in a grade of 0 for all parties involved.Make sure file is Virus free. Any file received with a virus will receive a grade of Any file containing VIRUS Receives A GRADE OF ZERODue Date: November 7th, 11:30 p.m. Send me the completed files via the D2L drop box Assignments submitted to the wrong dropbox folder will receive a grade of ZERO ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download