Unit 2 Assignment – Case Study 1 (CIS250 Advanced Excel)

 

Attached Files:

  • File (361.746 KB)
  • File (14.264 KB)

In this case study, you have been tasked with generating a loan approval workbook that will determine if an applicant is eligible for a personal loan and if so, what the loan rate should be based on a set of pre-defined criteria. The bank manager has created the basic layout of the application she wants to use but has asked you to provide the formulas that will drive the initial quote.Refer to the attached document for assignment details and grading rubric.