Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Automated Stock Trading Systems
Authors: Laurens Bensdorp
1st Edition
1544506031, 978-1544506036
