Weekly Annuity Calculation Method

To calculate the weekly installment amount, there are two approaches that can be used: using daily compound periods or using weekly compound periods. Both approaches can be calculated using the PMT function in Excel. In summary, the frequency of the principal payment affects the interest rate compound period per year and there are two valid approaches to calculate the weekly installment amount.
  • #1
k3wlm4n
1
0

Homework Statement


Consider a new Loan as below:
InterestRate = 56.558% annual in arrear
Amount = 1.000.000
Principal Payment Period = weekly (7 Days)
Term = 25 weeks

Homework Equations


How to calculate the weekly installment amount?
How's this "weekly principal payment" term has affect to the Interest rate compound period per year?

The Attempt at a Solution


two approach that I know of: (using excel)
1. compound periods per year using daily, so 1 week means 7 Days
- formula: PMT(InterestRate * 7 / 360 ,Term,-Amount,0,0)

2. compound periods per year using weekly, which is 50 week a year (I was told we only use 50 and not use 52 weeks a year, the same goes with using 360 days a year instead of 365 a year)
- formula: PMT(InterestRate / 50,Term,-Amount,0,0)

So any help? Which of the two is valid? or perhaps any other more valid approach beside those two?
 
Physics news on Phys.org
  • #2
The weekly principal payment term affects the interest rate compound period per year because it determines how often the interest is compounded. If the interest is compounded weekly, then there will be 50 compound periods per year. If the interest is compounded daily, there will be 360 compound periods per year.
 

Related to Weekly Annuity Calculation Method

1. What is the Weekly Annuity Calculation Method?

The Weekly Annuity Calculation Method is a mathematical formula used to determine the amount of a weekly annuity payment. This method takes into account factors such as the initial investment amount, interest rate, and annuity period to calculate the fixed weekly payments.

2. How does the Weekly Annuity Calculation Method differ from other annuity calculation methods?

The Weekly Annuity Calculation Method differs from other methods such as the monthly or annual calculation methods in that it calculates payments on a weekly basis rather than monthly or yearly. This can result in smaller but more frequent payments.

3. What is the benefit of using the Weekly Annuity Calculation Method?

The benefit of using the Weekly Annuity Calculation Method is that it provides a steady stream of income on a weekly basis, which can be helpful for budgeting and managing expenses. It also allows for more frequent payouts compared to other annuity calculation methods.

4. Are there any drawbacks to using the Weekly Annuity Calculation Method?

One potential drawback of using the Weekly Annuity Calculation Method is that the payments may be smaller compared to other methods, which could make it more challenging to cover larger expenses. Additionally, the annuity period may be shorter due to the more frequent payments.

5. Can the Weekly Annuity Calculation Method be used for all types of annuities?

The Weekly Annuity Calculation Method can be used for fixed annuities, which have a guaranteed interest rate and fixed payment amount. However, it may not be suitable for variable annuities, which have fluctuating interest rates and payment amounts based on market performance.

Similar threads

  • General Math
Replies
3
Views
2K
Replies
30
Views
7K
  • Precalculus Mathematics Homework Help
Replies
10
Views
5K
  • General Math
Replies
2
Views
2K
  • Precalculus Mathematics Homework Help
Replies
14
Views
7K
  • Introductory Physics Homework Help
Replies
3
Views
2K
  • Introductory Physics Homework Help
Replies
18
Views
4K
  • Introductory Physics Homework Help
Replies
10
Views
2K
  • Materials and Chemical Engineering
Replies
12
Views
756
Back
Top