Project Spreadsheet
Review
This assignment can be accessed in under Content in D2L by
choosing:
MyFinanceLab Links
MyFinanceLab All Assignments
and then selecting this assignment.
The project
assignment is designed to allow the student to pull together many of the
concepts and
techniques discussed throughout the course. All questions in
the spreadsheet project must be answered
in MyFinanceLab. The project must be submitted by Class
Meeting 7.
In addition to
answering the Spreadsheet Project questions in MyFinanceLab, students must
submit a
spreadsheet displaying how the answers were calculated in
the Learning Studio Dropbox. Each problem
should be answered on a clearly labeled separate worksheet
of a spreadsheet. Answers should be
formatted in a manner that makes the answers clear and easy
to read.
Each of the
following Excel functions should be used to calculate at least one of the
answers: FV, PV, PMT, RATE, NPER, NPV, AVERAGE, STDEV, and IRR. Calculating the
answers elsewhere and typing or pasting them into the spreadsheet is
unacceptable and will result in substantial grade deductions. The spreadsheet
project submitted should be a single-file readable in Microsoft Excel.
