Master Budget Assignment

Required: Today is December $31,2024.$ Year$-$end is done and the company's balance sheet at December $31,2024$ is available to you. Please build a quarterly budget forecast for $2025$ using the information below. Your forecast will result in projected financial statements including cash projections, an income statement and a balance sheet.

Build your spreadsheet so that the calculations are linked avoiding hard$-$coded numbers where ever possible. Where a per cent or number needs to be entered, list it in the "Data Assumptions" section and then link to it$.$ Some of those have already been listed for you, but you will need to add more information as you go$.$ That way a user can see what assumptions you have used and change them easily. Once its built, your financial statements should balance and reconcile.

There is a starting template provided to give you some guidance on the structure. You MUST use this template. Do not start a file of your own. That will receive a grade of zero.

The balance sheet at December $31,2024$ is below:

$\backslash$table$[[$Balance Sheet,Dec$-24],[$Cash$,5,000,000$