Create an Amortizing Schedule user defined R function for Excel
We build a user defined function for Excel to output a Mortgage Schedule. This is created in R and transposed to Excel by applying the BERT add in. Please view here for context:
https://sites.google.com/view/vinegar...
Google Colab with R code
https://colab.research.google.com/dri...
Basic Question:
A borrower wishes to take out a mortgage of €120,000 for a term of 30 years. What is her monthly repayment if the interest rate is fixed at 5%?
See explanation here:
• Setting Out a Mortgage Repayment Sche...
and how to run R in Google Colab
• Two ways to run R code in Google Colab
Install RStudio
• RStudio Installation Process and Test
Download and set up BERT R add in for Excel
• BERT Download and Installation for se...
Mortgage Schedule basic setup:
• Setting Out a Mortgage Repayment Sche...