Question: How do I forecast the following? Please use excel and explain step by step including formulas used to obtain answers. I'm really confused and I

How do I forecast the following? Please use excel and explain step by step including formulas used to obtain answers. I'm really confused and I need to know how to explain this method. Please type your response, handwriting can be difficult sometimes. Thank you!

Year	Grants and Contracts	% Increase	Moving averages

2018	22,491,694
2019	29,362,954
percentage increase
2020
2021
2022
2023
2024
2025

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Case Study Muesli AG Introduction The management at Muesli AG fully understands the importance of budgeting not only to help reach company goals, but also to keep the companyfocused on its plans for...

Answers are mostly provided but would like steps how to replicate and explain in excel adding in STP and LTP and explanation please. Question 1. Capital Allocation Lines. Suppose different hospitals...

Case 2 Geo Tech Cash Flow Template (Base Case) Year 0 1 2 3 4 5 $600,000.00 $1,080,000.00 $1,050,000.00 $750,000.00 $570,000.00 Revenues Cash Costs Set up $280,000.00 $420,000.00 $280,000.00...

please explain step by step, don't just give the answers. explain step by step with formulas please Troy Enpines, Limhed, mamfactures a variety of engines for use in heavy equipment. The compary has...

Please Show all details in how you got the answers step by step. DO NOT JUST PUT THE ANSWER. I want to actually learn how to solve the problem. Please use excel and also put the formulas so I can...

Master Budget Case Cordon Ltd. is a company that manufactures and sells a single product, which they call a Bleu. For planning and control purposes they utilize a monthly master budget, which is...

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

I have a Project I am working on for Portfolio Management. I finished most of the data entry and creating of tabs, but I still have about 30% of the project that I need help on. I expect it to take...

i need a tutor to help me finish the financial planning assignment. 1202AFE Financial Planning 1 Semester 2, 2016 File Note - Statement of Advice Client's name: Date of contact: Re: Liam Sem 17...

Consider a system which System of three spins S, S2, 11 can take values +1 and -1. The energy of 4 1, & and 5: 3.3 the system is given by E = -J [S S + S 3 + $85), where J is a positive constant....

Kirsten believes her company's overhead costs are driven (affected) by the number of direct labor hours because the production process is very labor intensive. During the period, the company produced...

what happens to equity when assets go up and liabilities go down

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...