Question

  • Creator
    Topic
  • #2170072

    Excel Formulas

    Locked

    by aletvdw ·

    Tags: 

    Hi Guys,

    Do not know if I can ask this here

    I want to try and do a spread sheet for my retirement. Say I have 20 years left to work and I want to have $100 000 the day I retire. I want to be able to have a sheet where I can see that I am say in the 10th year and that by this time I should have saved 50 000 for my retirement. It must then show this to me in a value of between 1 – 10 in this case it would be 5 as I am halve way there.

    I then also want to make a sheet where it show the following
    Say my debt is a $1000 dollar a week

    I must work every week to pay this amount
    This will be calculated over 10 weeks.
    If I work 10 weeks I must have $1000 in the bank to make sure I can pay the $1000
    If I only worked 9 out of the 10 week I must have $2000 in the bank to ensure that I will be able to pay for the week that I did not work. So I want to ensure that I always have enough money in the bank to be able to pay my debts if I do not work. So if I only worked 3 out of the 10 weeks I must have $7000 in the bank to be able to survive.
    I will input every week if I worked or not
    This must also then tell me where I am on a scale of 1 -10
    10 being that I worked all 10 weeks and is good
    1 being I only worked 1 week and need to ensure there is $9000 in the bank to be able to pay everything. Basically 1 will tell me I am in trouble and 10 that I am good (same for the 1st sheet)

All Answers

  • Author
    Replies
Viewing 0 reply threads