Excel.
- Can You Show Me How To Calculate The Break Even Point Using Excel 1 (24.55 KiB) Viewed 92 times
Can you show me how to calculate the break even point using Excel.
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Can you show me how to calculate the break even point using Excel.
Can you show me how to calculate the break even point using
Excel.
7 years ago a fixed rate mortgage for $100,000 was issued which would fully amortize monthly in 20 years. The contract rate was 8%. Refinancing costs $3,000 Now tha rates have fallen to 6%. What is the monthly payment? What is the loan balance? What is the Break-even rate for refinancing? BER Is refinancing a good idea?
Excel.
7 years ago a fixed rate mortgage for $100,000 was issued which would fully amortize monthly in 20 years. The contract rate was 8%. Refinancing costs $3,000 Now tha rates have fallen to 6%. What is the monthly payment? What is the loan balance? What is the Break-even rate for refinancing? BER Is refinancing a good idea?