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?

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?

I have fixed interest rate and monthly payment. How do I 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?

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?