Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Inflation calculation Excel formula help: Inflation is 2% per year, broken down on a monthly basis in each cell. It should be something that I

Inflation calculation Excel formula help:

Inflation is 2% per year, broken down on a monthly basis in each cell. It should be something that I can just drag to copy to the rest of the cells, so that's what I'm trying to figure out. PLEASE PROVIDE CELL REFERENCES FOR WHAT TO CLICK AND FORMAT OF FORMULA I NEED TO USE. Screen shot of everything is ok.

The below image is what I need to recreate (ONLY THE INFLATION CALCULATION PART--It's my multiplier for the rest of the spreadsheet), which is what I am asking you for help to do:

image text in transcribed

Row A has month references; Colum C Row 4 is the annual inflation rate. Monthly inflation Row 4 Column D and onward.

I am asking for the fill-formula to do be able to expand this to the right, all the way to month 72. What do I do?

1 1/1/2022 2022 1 2 2/1/2022 2022 1.001666667 3 3/1/2022 2022 1.003336111 4 4/1/2022 2022 1.005008338 5 5/1/2022 2022 1.006683352 6 6/1/2022 2022 1.008361157 7 7/1/2022 2022 1.010041759 8 8/1/2022 2022 1.011725162 9 9/1/2022 2022 1.013411371 10 10/1/2022 2022 1.01510039 Inflation 296

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Core Concepts

Authors: Raymond M Brooks

3rd edition

133866696, 978-0133866698

More Books

Students also viewed these Finance questions

Question

What is Entrepreneur?

Answered: 1 week ago

Question

Which period is known as the chalolithic age ?

Answered: 1 week ago

Question

Explain the Neolithic age compared to the paleolithic age ?

Answered: 1 week ago