Question

How would I write in excel a formula for started at 60 % and increase their...

How would I write in excel a formula for

started at 60 % and increase their capacity factor by 16 % a year till they reached a 100% capacity factor. (This meant that the capacity factor for year 2, CF2, would be = CF1*(1+growth_rate),

and stop once it hit 100%

Homework Answers

Answer #1

ANSWER IN THE IMAGE ((YELLOW HIGHLIGHTED). FEEL FREE TO ASK ANY DOUBTS. THUMBS UP PLEASE.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
How do I write a macro in excel for the CAPM formula??
How do I write a macro in excel for the CAPM formula??
How do I write a formula in a cell for Excel for this statement: "In cell...
How do I write a formula in a cell for Excel for this statement: "In cell B27, determine the hold time failure rate by using the SUM function to total the values in column I and then dividing that sum by the total number of calls overall in cell B6."
Please write formulas and not solve in excel, i need to hand write and show work...
Please write formulas and not solve in excel, i need to hand write and show work on the test. 1. You invested $100 in investment B for 2 years, and $100 in investment B for 1 year. Your rate of return for both years was exactly the same. If at the end of the 2 years the money grew to $215.25. What was your compound return? 2. You invested $100 in investment A, Year 1 it grew by 10%, Year...
See below. I have the excel formula for a-c, i need to know how to calculate...
See below. I have the excel formula for a-c, i need to know how to calculate d-f in excel. The Wall Street Journal reported that long term Treasury bonds had a mean return of 24.03% in 2008. Assume that the returns for the long term Treasury bonds were distributed as a normal random variable, with a mean of 24.03 and a standard deviation of 10. If you select an individual Treasury bond from this population, what is the probability that...
I need the EXCEL formula for the following questions, please. What is the formula to calculate...
I need the EXCEL formula for the following questions, please. What is the formula to calculate how much a savings account would be worth if the initial balance is $1,000 with monthly deposits of $75 for 10 years at 4.3% annual interest compounded monthly? What is the formula result? You want a savings account to grow from $1,000 to $5,000 within two years. Assume the bank provides a 3.2% annual interest rate compounded monthly. What is the formula to calculate...
How do I solve this in Excel: Let x be a normally distributed random variable with...
How do I solve this in Excel: Let x be a normally distributed random variable with mean 16 and standard deviation 14. Please express your answer as a number between 0 and 100. If you want to write 52%, please enter 52. What is the probability that x is between 14 and 28?
Hi, I would like to know how to solve this stats question using only Excel. The...
Hi, I would like to know how to solve this stats question using only Excel. The mean work week for engineers in a start-up company is believed to be about 60 hours. A newly hired engineer hopes that it’s shorter. She asks ten engineering friends in start-ups for the lengths of their mean work weeks. Based on the results that follow, should she count on the mean work week to be shorter than 60 hours? Data (length of mean work...
Does anyone know how to calculate the expected cumulative relative frequency? I would appreciate you write...
Does anyone know how to calculate the expected cumulative relative frequency? I would appreciate you write the formula in here.
How do i do these using excel and its functions 15.       Find the present value of...
How do i do these using excel and its functions 15.       Find the present value of a $1000 annuity that begins at the end of the 3rd year and continues until the end of the 10th year, given a 12% discount rate. 16.       Calculate the value today that is equivalent to $150 at the end of year 1, $450 at the end of year 2, and $300 at the end of year 3, given a discount rate of 10%.
It is my question : how to write the formula of hoarmnic numbers in vba {1+1/2+1/3+1/4+....)...
It is my question : how to write the formula of hoarmnic numbers in vba {1+1/2+1/3+1/4+....) the sum is 10 and i would like to find the terms ..... thanks for your help Another question : thanks for your reply. How about the solution in visual basic? thanks a lot
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • IN PYTHON Add a while loop to this code so that it will replay the Game...
    asked 7 minutes ago
  • Build the subnetting tables for the following data (Classful addressing): IP: 192.44.82.16 Mask:255.255.255.192
    asked 15 minutes ago
  • If a future stream of payments is delayed, then the present value of that future stream...
    asked 21 minutes ago
  • Assume the random variable X is normally distributed with mean u=55 and standard deviation sigmaσequals=7. Compute...
    asked 21 minutes ago
  • John knows that monthly demand for his product follows a normal distribution with a mean of...
    asked 38 minutes ago
  • No one theory can account for all crimes. which theory of crime causation do you think...
    asked 48 minutes ago
  • Based on the below data: Customer1:Bread,Cereals,Milk Customer2:Tomatoes,Eggs Customer3:Pork,Bread,Milk Customer4:Sugar,Tomatoes,Pork,Bread Customer5:Vinegar Customer6:Eggs,Milk,Cereals,Sugar,Pork Customer7:Eggs,Milk,Vinegar Customer8:Sugar,Pork explain h
    asked 50 minutes ago
  • Pleas write a program that checks if any array of string is a plaindrome required input:...
    asked 56 minutes ago
  • A parallel-plate capacitor with plates of area 720 cm2 is charged to a potential difference V...
    asked 59 minutes ago
  • Develop an algorithm and a program in C that asks the user to enter a positive...
    asked 1 hour ago
  • The principal of Paul Revere High School bragged that his 2016 graduating class of 1500 students...
    asked 1 hour ago
  • Height is normally distributed with a mean of 68 inches and a standard deviation of 3...
    asked 1 hour ago