CISC 181 Excel Assignment - Easy assignment. Check attachments
fiendin
exploring_e07_grader_h1.xlsx
Summary
| Search Engine |
| Unit # | | | Rental Price |
| List of Rental Property |
| Unit # | Apartment Complex | # Bed | Rental Price | Occupied | Last Remodel | Pet Deposit | Recommendation |
| 101 | Rolling Meadows | 1 | $ 750.00 | Yes | 2004 |
| 103 | Rolling Meadows | 2 | $ 850.00 | No | 1999 |
| 104 | Rolling Meadows | 2 | $ 850.00 | Yes | 2005 |
| 105 | Rolling Meadows | 3 | $ 1,000.00 | No | 2007 |
| 302 | Lakeview Apartments | 1 | $ 875.00 | No | 2001 |
| 303 | Lakeview Apartments | 1 | $ 900.00 | No | 2001 |
| 306 | Lakeview Apartments | 2 | $ 1,200.00 | Yes | 2004 |
| 406 | Mountaintop View | 3 | $ 1,200.00 | No | 2002 |
| 407 | Mountaintop View | 2 | $ 975.00 | Yes | 2002 |
| 408 | Mountaintop View | 2 | $ 975.00 | Yes | 2002 |
| 501 | Sunset Valley | 1 | $ 550.00 | Yes | 2010 |
| 502 | Sunset Valley | 1 | $ 550.00 | No | 2010 |
| 503 | Sunset Valley | 1 | $ 550.00 | No | 2003 |
| 504 | Sunset Valley | 1 | $ 550.00 | Yes | 2003 |
| 505 | Sunset Valley | 2 | $ 700.00 | No | 2003 |
| 605 | Oak Tree Living | 3 | $ 1,500.00 | No | 2010 |
| 606 | Oak Tree Living | 3 | $ 1,500.00 | Yes | 2004 |
| 607 | Oak Tree Living | 3 | $ 1,500.00 | No | 2004 |
Database
| Criteria Range |
| Unit # | Development | Unit # | # Bed | Rental Price | Occupied | Last Remodel | Recommendation |
| Database Statistics |
| | No. of Apts. to Remodel |
| | Value of Lost Rent |
| | Year of Oldest Remodel |
| List of Rental Property |
| Unit # | Development | # Bed | Rental Price | Occupied | Last Remodel | Recommendation |
| 101 | Rolling Meadows | 1 | 750 | Yes | 2004 | No change |
| 103 | Rolling Meadows | 2 | 850 | No | 1999 | Need to remodel |
| 104 | Rolling Meadows | 2 | 850 | Yes | 2005 | No change |
| 105 | Rolling Meadows | 3 | 1,000 | No | 2007 | No change |
| 302 | Lakeview Apartments | 1 | 875 | No | 2001 | Need to remodel |
| 303 | Lakeview Apartments | 1 | 900 | No | 2001 | Need to remodel |
| 306 | Lakeview Apartments | 2 | 1,200 | Yes | 2004 | No change |
| 406 | Mountaintop View | 3 | 1,200 | No | 2002 | Need to remodel |
| 407 | Mountaintop View | 2 | 975 | Yes | 2002 | No change |
| 408 | Mountaintop View | 2 | 975 | Yes | 2002 | No change |
| 501 | Sunset Valley | 1 | 550 | Yes | 2010 | No change |
| 502 | Sunset Valley | 1 | 550 | No | 2010 | No change |
| 503 | Sunset Valley | 1 | 550 | No | 2003 | Need to remodel |
| 504 | Sunset Valley | 1 | 550 | Yes | 2003 | No change |
| 505 | Sunset Valley | 2 | 700 | No | 2003 | Need to remodel |
| 605 | Oak Tree Living | 3 | 1,500 | No | 2010 | No change |
| 606 | Oak Tree Living | 3 | 1,500 | Yes | 2004 | No change |
| 607 | Oak Tree Living | 3 | 1,500 | No | 2004 | Need to remodel |
Loan
| Input Area | | | Summary Calculations |
| Complex Cost | $ 850,000.00 | | Loan Amount |
| Down Payment | $ 375,000.00 | | No. Periods |
| # of Pmts per Year | 12 | | Monthly Rate |
| Years | 30 | | Monthly Payment |
| APR | 5.75% | | Total Interest Paid |
| 1st Payment Date |
| Payment # | Payment Date | Beginning Balance | Interest Paid | Principal Payment | Ending Balance |
