Weekly Annuity Calculation Method

Click For Summary
SUMMARY

The discussion focuses on calculating weekly annuity payments for a loan with an interest rate of 56.558% per annum over a term of 25 weeks. Two methods are proposed for determining the weekly installment amount using Excel's PMT function: one using daily compounding with 360 days per year and another using weekly compounding with 50 weeks per year. The validity of these approaches hinges on the compounding frequency, which directly influences the interest calculation. The consensus is that the choice of compounding period significantly affects the total interest paid over the loan term.

PREREQUISITES
  • Understanding of Excel functions, specifically PMT
  • Knowledge of loan amortization concepts
  • Familiarity with interest rate compounding methods
  • Basic financial mathematics
NEXT STEPS
  • Research the implications of different compounding frequencies on loan payments
  • Learn how to implement Excel's PMT function for various loan scenarios
  • Explore the differences between using 360 days versus 365 days in financial calculations
  • Investigate alternative methods for calculating annuity payments beyond Excel
USEFUL FOR

Finance students, loan officers, financial analysts, and anyone involved in calculating loan payments or understanding annuity structures.

k3wlm4n
Messages
1
Reaction score
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
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.
 
The book claims the answer is that all the magnitudes are the same because "the gravitational force on the penguin is the same". I'm having trouble understanding this. I thought the buoyant force was equal to the weight of the fluid displaced. Weight depends on mass which depends on density. Therefore, due to the differing densities the buoyant force will be different in each case? Is this incorrect?

Similar threads

  • · Replies 30 ·
2
Replies
30
Views
7K
Replies
10
Views
6K
  • · Replies 18 ·
Replies
18
Views
4K
Replies
3
Views
2K
  • · Replies 20 ·
Replies
20
Views
3K
  • · Replies 2 ·
Replies
2
Views
2K
Replies
14
Views
7K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 9 ·
Replies
9
Views
5K