FRIRC
1) Fed Rate Linkage Inputs
Discount ⇄ Funds ⇄ Prime
How this works: Funds = Discount − (Discount→Funds spread). Prime = Funds + (Funds→Prime spread).
Presets just fill typical spreads; you can override them for realism.
2) Savings / Cash Value (Monthly Compounding)
Editable growth rate
Savings/CV is modeled as: monthly deposit at month-end + monthly compounding.
“Real” values use an inflation-adjusted growth rate for a purchasing-power view.
3) Loan Inputs + Rate Transmission (Auto)
Commercial vs Policy Loan
Auto-derived rates:
Bank loan rate = Prime + (Bank spread).
Policy loan rate = Funds + (Policy spread).
Payments are calculated with standard amortization.
Bank loan rate = Prime + (Bank spread).
Policy loan rate = Funds + (Policy spread).
Payments are calculated with standard amortization.
Results (Simplified, Accurate Math)
30-year viewCompare Net Financial Assets
Definitions used:
• Savings/CV = starting balance + monthly deposits + monthly compounding.
• Loan balance evolves by amortization once the loan starts.
• Net Financial Assets = Savings/CV − Loan balance.
If you want “net worth including the purchased asset,” that’s a different model (you’d add asset value).
• Savings/CV = starting balance + monthly deposits + monthly compounding.
• Loan balance evolves by amortization once the loan starts.
• Net Financial Assets = Savings/CV − Loan balance.
If you want “net worth including the purchased asset,” that’s a different model (you’d add asset value).
(Defaults to Nominal)
Comments
Post a Comment