Financial Calculation Problem

Watch
This discussion is closed.
Kev
Badges:
#1
Report 17 years ago
#1
Help!

I am working on a calculator to work from an APR to repayments, lets say over 36 months. This is
easy enough to do in Excel when the loan is in the format

£10000 Loan £1000 deposit £9000 borrowed over 36 months

I can convert APR to IRR and whip out the numbers in excel, however

when the loan is structured as follows

£10000 Loan 3 payments deposit 33 repayments

I get stuck, the amount lent is not fixed and varies according to what the repayments are to be,
which I don't know until I calculate them?!?!

Is this clear, I hope so and hopefully this is in the right NG, if not sorry
=)

----------------------------------------
Never anger a dragon, for you are crunchy and you go well with Brie.
----------------------------------------
0
X
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

Regarding Ofqual's most recent update, do you think you will be given a fair grade this summer?

Yes (263)
33.98%
No (511)
66.02%

Watched Threads

View All