# Need "reverse" amortization; calculate loan amount

1. ## Re: Need "reverse" amortization; calculate loan amount

You also need the number of payments.
Look in HELP for the PV() function

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
>I have fixed interest rate and monthly payment. How do I calculate loan
> amount?

2. ## Re: Need "reverse" amortization; calculate loan amount

Look at Help on PV function

"MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
>I have fixed interest rate and monthly payment. How do I calculate loan
> amount?

3. ## Re: Need "reverse" amortization; calculate loan amount

You also need the number of payments.
Look in HELP for the PV() function

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
>I have fixed interest rate and monthly payment. How do I calculate loan
> amount?

4. ## Re: Need "reverse" amortization; calculate loan amount

Look at Help on PV function

"MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
>I have fixed interest rate and monthly payment. How do I calculate loan
> amount?

5. ## Need "reverse" amortization; calculate loan amount

I have fixed interest rate and monthly payment. How do I calculate loan
amount?

6. ## Re: Need "reverse" amortization; calculate loan amount

You also need the number of payments.
Look in HELP for the PV() function

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
>I have fixed interest rate and monthly payment. How do I calculate loan
> amount?

7. ## Re: Need "reverse" amortization; calculate loan amount

Look at Help on PV function

"MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
>I have fixed interest rate and monthly payment. How do I calculate loan
> amount?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1