+ Reply to Thread
Results 1 to 2 of 2

how to make compound interest calculatr with options 1.take tax once per year 2. inflation

  1. #1
    Forum Contributor
    Join Date
    04-01-2015
    Location
    Sydney Australia
    MS-Off Ver
    Office 365 latest
    Posts
    171

    Lightbulb how to make compound interest calculatr with options 1.take tax once per year 2. inflation

    Hi,

    Ive found many excel compount interest functions on google but I want to create a calculator sheet that allows me to have an option to

    1. take out tax once a year, so I input a tax % and thats removed after a 12 month compounding cycle, for annual taxes
    2. put in an inflation figure so the compounding is adjusted for inflation as an option.

    3. option to choose how much and how often a deposit is added to the investment. weekly,fortnightly,monthly.

    =FV(rate,nper,pmt,pv) is what I have.

    but thats it.

  2. #2
    Forum Contributor
    Join Date
    04-01-2015
    Location
    Sydney Australia
    MS-Off Ver
    Office 365 latest
    Posts
    171

    Re: how to make compound interest calculatr with options 1.take tax once per year 2. infla

    what are the commercial services? how much would it cost for someone to create this sheet for me and reveal the code, show me how it works?
    kindly.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need formula to figure compound interest of a deposit for a year
    By Don in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 11:05 AM
  2. [SOLVED] Need formula to figure compound interest of a deposit for a year
    By Don in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 07:05 AM
  3. [SOLVED] Need formula to figure compound interest of a deposit for a year
    By Don in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  4. [SOLVED] Need formula to figure compound interest of a deposit for a year
    By Don in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  5. [SOLVED] Need formula to figure compound interest of a deposit for a year
    By Usedtobesmart in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] Need formula to figure compound interest of a deposit for a year
    By Usedtobesmart in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] Need formula to figure compound interest of a deposit for a year
    By Usedtobesmart in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. Need formula to figure compound interest of a deposit for a year
    By Usedtobesmart in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2005, 01:34 PM

Tags for this Thread

Bookmarks

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