Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I figure this out in an excel spreadsheet? Method 1: I put $1250 per month into notes that make monthly principal and interest
How do I figure this out in an excel spreadsheet?
Method 1:
- I put $1250 per month into notes that make monthly principal and interest payments at 15%
- Notes have a 36-month term
- Every month, I invest another $1250, PLUS the previous months cashflow in similar notes (the amount invested grows slightly every month)
- After 36 months, what is the monthly cash flow from principal and interest, AND what is the value of the outstanding notes (underlying assets)
Method 2:
- I borrow $10,000 (assume 6%) and buy exact same notes in bigger quantity
- I use the $1250 per month, PLUS the cash flow to pay down the $10,000 instead of buying notes
- When the note is paid off, I reborrow it and buy another 10k in notes
- This pay-down and reborrow cycle gets shorter every time due to the added cash flow from previous flips
- At the end of 36 months, how does the cash flow and underlying asset value compare to method 1?
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