Stack Overflow
Stack Overflow

Questions tagged [amortization]

Amortization is the process of decreasing, or accounting for, an amount over a period. (For questions about amortized analysis in algorithms and data structures, use [amortized-analysis]).

46 questions
3
votes
1 answer

How to check cell value to change value of another?

I am working on a loan amortization project. The loan is amortized over a period of time. Let's say 20 years which has 239 payment lines. The last row which is generated automatically via an if formula needs some Reconciliations As long as the last…
Mohammed Alamoudi
  • 21
  • 1
3
votes
6 answers

Generating An Amortization Schedule

I have been tasked with creating a program that will generate an amortization schedule. I have only done a bit of research so far, but I need to calculate out payments, interest per payment and principal per payment. Can any one point me in the…
Mike Wills
  • 20,959
  • 28
  • 93
  • 149
2
votes
1 answer

Calculate PMT from multiple principals in Excel

I am preparing a cashflow statement where I take a loan every month - all at the same interest rate and duration. Thus, I need to forecast EMI, interest, and principal for each month from all the loans taken so far. In reality, I figured out PMT. I…
Shahid Thaika
  • 2,133
  • 5
  • 23
  • 59
2
votes
1 answer

Create Loop for Amortization Schedule in Swift

I'm looking to figure out a simple loop in order to calculate an amortization schedule in Swift. So far, here is my setup on Playground: let loanAmount: Double = 250000.00 let intRate: Double = 4.0 let years: Double = 30.0 var r: Double = intRate /…
ckraider
  • 335
  • 5
  • 19
1
vote
2 answers

Amortizing the calculation of distribution (and percentile), applicable on App Engine?

This is applicable to Google App Engine, but not necessarily constrained for it. On Google App Engine, the database isn't relational, so no aggregate functions (such as sum, average etc) can be implemented. Each row is independent of each other. To…
Oliver Zheng
  • 7,831
  • 8
  • 53
  • 59
1
vote
1 answer

Cross-referecing columns in Snowflake SQL

I'm trying to build an amortization schedule using Snowflake-SQL however I need two columns to reference each other in order to calculate the active and the present value. In excel, it would be something like this: In SQL, I tried doing it like…
Marco K
  • 35
  • 4
1
vote
4 answers

Creating an amortization schedule in snowflake

I have a view in snowflake that gives me the following: loan date loan amount maturity date payment frequency (weekly, biweekly, semimonthly, monthly) payment amount I want to generate a sort of amortization schedule off of this, if you will. So…
mark knipfer
  • 15
  • 3
1
vote
2 answers

Amortization Schedule on Python

I have been working on an amortization schedule using python. however, when I run the code the output does not give me the correct results, instead it appears is looping and printing the same values across, 360 times. Below is the code I…
Odez
  • 11
  • 1
1
vote
0 answers

How do I store the values from a loop in a dataframe in R?

I'm n making a program that compares owning vs renting apartments. As a part of the program I want to create a dataframe of an annuity loan with the interest and principal payments and the remaining balance. The calculations for the loan are easy,…
Aite97
  • 155
  • 1
  • 9
1
vote
1 answer

Ruby on Rails Loan Amortization Schedule

What would be the best way to incorporate a loan amortization schedule in my rails app? Is it possible? Is ruby on rails even a good way to implement something like that? I have built them in excel a few times before, but just can't picture how to…
FattRyan
  • 906
  • 2
  • 12
  • 26
1
vote
2 answers

Amortized cost calculation using VBA (Bond)

I am trying to make an "accounting" model for Amortized cost. I will make one array with the actual payment dates, one array with the "amortized cost" and another array showing values at reporting day (e.g. 31.12). I have already made this…
EVO
  • 11
  • 3
1
vote
1 answer

Using prior line record in next line record SQL

[The data set above is what I have created. What I'd like to do is loop the last column (New_UPB) and have that be the first column in the next line of records and have the data set continue until the UPB reaches 0.]1 So that the outcome is this: I…
misterc625
  • 37
  • 2
  • 4
1
vote
1 answer

Why the total_loan is not working( is the same as total_interest), and also Idk how to show the schedule correctly

I have to do an amortization schedule and the output should be: Mortgage term in years Mortgage interest rate Mortgage amount Total interest amount Total Mortgage amount Monthly Mortgage Payments & Mortgage Loan Balance for each month. If the…
ma_rodrigues
  • 33
  • 1
  • 1
  • 4
1
vote
2 answers

Amortization Table

This program will calculate the amortization table for a user. The problem is my assignment requires use of subroutines. I totally forgot about that, any ideas on how to modify this to include subroutines? public class Summ { public static void…
akhg2235
  • 7
  • 1
  • 6
1
vote
1 answer

Using VLOOKUP with multiple criteria/multidimensional Vlookup

I am trying to create an amortisation table where the interest rate depends on two inputs provided by the user. X represents rows and Y represents columns. Values of X, Y and interest rates are already set in a 4 X 6 table. For example if the user…
Samia
  • 13
  • 3
1
2 3 4