+ Reply to Thread
Results 1 to 3 of 3

How to calculate percentage rate increase with annual summary?

  1. #1
    Registered User
    Join Date
    06-05-2014
    Posts
    2

    How to calculate percentage rate increase with annual summary?

    What I need is a worksheet which will generate fields from a set of variables (similar to a loan amortization schedule).
    I don't know how to write the field code to include the annual percentage rate increase based on that additional input variable.

    Input variables would be:
    starting rate: (ex: 8¢/kilowatt hour)
    starting date: (ex: July 2013)
    average kw hours/month: (ex: 1062.5 kw hours)
    annual rate increase: (ex: 3% *default 0%)
    years to display: (ex: 25 years, *shown in months in fields below)
    service months per year: (ex: 12 *default 12)
    cost of solar system installation: (ex: $14,000)
    rebate of cost of solar system installation: (ex: $4,000 *default $0)
    rate of purchase agreement: (ex: 12¢/kilowatt hour)
    annual rate increase of purchase agreement: (ex: 3% *default 0%)

    So, data fields below the variables would be blank until these are entered.
    Assume I would protect the sheet to avoid messing it up.
    Ideally this would generate a chart showing rates over time from the fields below.
    Also it would generate fields in a summary area to show the rate per year for future years.
    Secondary, if there were a way to input actual usage and rates from specific months in the past, that would be useful but not part of this forecast model.

    The goal of this model is to forecast electrical costs for residential power users compared to independent solar power generation to 25 years forward.
    I want to make this because I am skeptical of the advertised savings that solar installers use to convince clients that their return on investment is so high. I believe their data to be greatly inflated projections.
    Using this in comparison with other data such as inflation and wages will allow me to get a very good economic picture of the future of independent solar energy generation and its impact on the average home owner.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: How to calculate percentage rate increase with annual summary?

    My tiny head can't cope with this. Can you try to get this onto a spreadsheet and post it here show us a bit more about how the data will be structured, what you need to be calculated from what, and what you need as outputs?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    06-05-2014
    Posts
    2

    Re: How to calculate percentage rate increase with annual summary?

    Attached early draft
    Attached Files Attached Files

+ 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. Replies: 8
    Last Post: 02-02-2020, 01:39 AM
  2. [SOLVED] Annual Percentage Rate
    By frustratedwthis in forum Excel General
    Replies: 3
    Last Post: 11-11-2005, 02:55 PM
  3. APR - Annual Percentage Rate to Actual Interest Rate
    By Safu in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-18-2005, 12:06 AM
  4. Annual Percentage Rate for Mortgage
    By Tristan in forum Excel General
    Replies: 3
    Last Post: 02-05-2005, 01:06 PM
  5. Annual Percentage Rate
    By sts111 in forum Excel General
    Replies: 1
    Last Post: 02-01-2005, 10:06 AM

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