Question: Excel Assistance: Loan Worksheet *Please provide full formula solutions for each column. **Full information below Loan Analysis Worksheet Purchase Price $500,000 Number of Compounding Periods/year
Excel Assistance: Loan Worksheet
*Please provide full formula solutions for each column.
**Full information below
| Loan Analysis Worksheet | ||||||||||
| Purchase Price | $500,000 | |||||||||
| Number of Compounding Periods/year | 4 | |||||||||
| Optional Balloon Payment | $ 20,000 | |||||||||
| Option# | Down Payment | Nominal Interest Rate/yr | Duration (yrs) | Points | Fees | Loan Value | Monthly Payment | Actual Amount Borrowed | APR | Payment with Balloon |
| 1 | 20% | 4.90% | 30 | 3 | 375 | |||||
| 2 | 10% | 5.25% | 30 | 3 | 375 | |||||
| 3 | 5% | 5.75% | 30 | 3 | 375 | |||||
| 4 | 0% | 6.25% | 30 | 3 | 0 | |||||
| 5 | 20% | 5.50% | 30 | 1 | 0 | |||||
| 6 | 10% | 6.00% | 15 | 0 | 350 | |||||
| 7 | 5% | 6.50% | 15 | 0 | 350 | |||||
| Private loan (1) annual rate: | ||||||||||
| Private loan (2) duration: | ||||||||||
| CD value enough for down payment: | ||||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock