mid term
neel
midterm_excel.xlsxQ2
| a | b | c | d | ||||||||||
| FV | FV | FV | FV | ||||||||||
| Years | Years | Years | Years | ||||||||||
| Interest Rate | Interest Rate | Interest Rate | Interest Rate | ||||||||||
| PMT | PMT | PMT | PMT | ||||||||||
| PV | ? | PV | ? | PV | ? | PV | ? |
Q5
| a | b | c | ||||||
| FV | FV | FV | ||||||
| Coupon Rate | Coupon Rate | Coupon Rate | ||||||
| Years | Years | ? | Years | |||||
| YTM | ? | YTM | YTM | |||||
| PMT | PMT | PMT | ||||||
| PV or P | PV or P | PV or P | ? |
Q12
| a | b and c | ||||||||||
| Mortgage | Months | Beginning Balance | Monthly Payment | Interest | Principle | Ending Balance | Share of interest | Share of Principle | |||
| Periods | |||||||||||
| Annual Interest Rate | |||||||||||
| Monthly Payment | ? | ||||||||||
| d | |||||||||||
| Total Interest Paid |
