We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

PCP calculations

Options
BOBBIE008
BOBBIE008 Posts: 1 Newbie
in Loans
Hi
This is my first post so please bear with me.
Ian looking to build an excel spreadsheet to calculate all the permatations of a PCP deal it is a project for my advanced excel course can anyone help?

Thanks

Comments

  • mcpitman
    mcpitman Posts: 1,267 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    Investigate "CUMPRINC" "PMT" and "RATE" calculations already set within Excel.
    Or write a looping Macro with the calculation principles embedded.
    Life isn't about the number of breaths we take, but the moments that take our breath away. Like choking....
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.7K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.4K Spending & Discounts
  • 243.7K Work, Benefits & Business
  • 598.5K Mortgages, Homes & Bills
  • 176.8K Life & Family
  • 256.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture