Financial Modeling Projections

1. Attached is an Actual versus Budget analysis for Company XYZ in Q1 2019 (January through March). Based on its year-to-date performance, project out Q2 through Q4 of 2019. Please include the following in your analysis:

a. Monthly projections for Q2-Q4 in Excel and include a column that sums up total FY2019

b. A brief write-up (in Word or Excel) that includes:

i. Any assumptions made in your analysis

ii. Any follow-up questions and considerations you have

2. Company JKL notices that it has been under-accruing expenses, thus resulting in understated expenses every month. Please provide a write-up with the following:

a. Recommendations you would make to improve the process

b. Stakeholders you would involve in this process

c. Timeline & other considerations you have to execute your plan