[ WebToolTip.com ] Udemy - FP and A in Excel - Budget, Forecast and Board Pack
File List
- ~Get Your Files Here !/5 - The Revenue Budget/18 - Bottom-up café revenue covers x average ticket, café by café.mp4 37.2 MB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/7 - Reading the trial balance and mapping it to the statements.mp4 26.6 MB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/6 - How the statements link retained earnings, cash, working capital.mp4 22.6 MB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/13 - Model layout inputs, calculations, outputs and one timeline.mp4 21.8 MB
- ~Get Your Files Here !/1 - Welcome/3 - Meet Harbour Coffee Co. cafés, roastery, and the FY2027 brief.mp4 20.9 MB
- ~Get Your Files Here !/5 - The Revenue Budget/21 - The new café Harbour Quay's ramp-up from its opening month.mp4 19.5 MB
- ~Get Your Files Here !/9 - The Integrated Master Budget/37 - Budgeted cash flow, indirect method, and the minimum cash test.mp4 19.4 MB
- ~Get Your Files Here !/5 - The Revenue Budget/17 - Analysing two years of actuals seasonality and revenue mix.mp4 18.8 MB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/51 - The mid-year reforecast run-rates, the late opening, costs and payroll.mp4 18.5 MB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/14 - Formatting conventions blue inputs, black formulas, green links.mp4 18.5 MB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/25 - Inventory valuation and the cost of sales summary.mp4 17.2 MB
- ~Get Your Files Here !/9 - The Integrated Master Budget/35 - Budgeted income statement and the income tax schedule.mp4 15.7 MB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/44 - Loading monthly actuals the data tabs and the Actuals sheet.mp4 15.6 MB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/15 - The assumptions sheet named inputs, scenario columns and a CHOOSE switch.mp4 15.3 MB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/23 - The materials budget green beans, roast loss, packaging and energy.mp4 14.6 MB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/47 - Cost variances rate vs efficiency on labour and beans.mp4 14.2 MB
- ~Get Your Files Here !/9 - The Integrated Master Budget/36 - Budgeted balance sheet making it balance (and finding why it doesn't).mp4 13.8 MB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/33 - Loan schedule drawdown, interest, repayments and covenants.mp4 13.0 MB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/16 - The checks sheet one place that proves the model adds up.mp4 12.9 MB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/46 - Price, volume and mix variance for café revenue.mp4 12.9 MB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/43 - Store #13 go no-go NPV, IRR and payback.mp4 12.7 MB
- ~Get Your Files Here !/7 - People and Operating Costs/27 - Payroll wages, salaries, the July pay rise and on-costs.mp4 12.6 MB
- ~Get Your Files Here !/7 - People and Operating Costs/29 - Allocating head office costs to regions.mp4 12.5 MB
- ~Get Your Files Here !/3 - How Budgeting Works in a Real Company/11 - Driver-based budgeting the few numbers that drive everything.mp4 12.1 MB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/53 - One-page FP&A dashboard KPIs, BvA, forecast and cash.mp4 11.8 MB
- ~Get Your Files Here !/9 - The Integrated Master Budget/39 - Sign-off presenting the budget to the CEO on one page.mp4 11.8 MB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/42 - Break-even per café and for the roastery.mp4 11.7 MB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/41 - Sensitivity analysis and a tornado chart.mp4 11.5 MB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/40 - Base, upside, downside one switch, three versions of the year.mp4 11.2 MB
- ~Get Your Files Here !/5 - The Revenue Budget/20 - Wholesale revenue customers, kilos and price per kilo.mp4 11.1 MB
- ~Get Your Files Here !/3 - How Budgeting Works in a Real Company/9 - Budget vs forecast vs plan vs target.mp4 10.5 MB
- ~Get Your Files Here !/3 - How Budgeting Works in a Real Company/12 - The master budget map which schedule feeds which.mp4 10.3 MB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/30 - Cash conversion cycle debtor, inventory and creditor days.mp4 10.0 MB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/49 - Latest estimate actuals to date plus budget, one timeline.mp4 9.7 MB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/4 - Three statements, one business a café day.mp4 8.8 MB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/52 - EBITDA and cash bridges from budget to reforecast.mp4 8.7 MB
- ~Get Your Files Here !/3 - How Budgeting Works in a Real Company/8 - What FP&A does all year the planning calendar.mp4 8.7 MB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/50 - FORECAST.ETS a statistical forecast vs driver judgement.mp4 8.4 MB
- ~Get Your Files Here !/5 - The Revenue Budget/19 - Top-down check management's target vs the bottom-up build.mp4 8.3 MB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/22 - Roastery production budget sales + closing stock - opening stock.mp4 7.9 MB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/31 - The working-capital budget debtors, stock and creditors by month.mp4 7.5 MB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/5 - Profit is not cash accruals, inventory and timing.mp4 7.1 MB
- ~Get Your Files Here !/7 - People and Operating Costs/28 - Operating costs fixed, variable and step costs.mp4 7.0 MB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/45 - BvA report month, YTD, favourable adverse and materiality.mp4 7.0 MB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/32 - Capex plan, fixed asset rollforward and depreciation.mp4 7.0 MB
- ~Get Your Files Here !/9 - The Integrated Master Budget/38 - KPI page margins, EBITDA, cash and covenant headroom.mp4 6.9 MB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/55 - Optional using AI to draft commentary and audit a model, safely.mp4 6.9 MB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/34 - Sales tax timing cash you collect but don't own.mp4 6.6 MB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/56 - Wrap-up what you can do now, and where FP&A careers go next.mp4 6.5 MB
- ~Get Your Files Here !/3 - How Budgeting Works in a Real Company/10 - Top-down vs bottom-up (and the negotiation in between).mp4 6.5 MB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/54 - Telling the story three messages for the board.mp4 5.9 MB
- ~Get Your Files Here !/1 - Welcome/2 - How to use this course + download the files.mp4 5.2 MB
- ~Get Your Files Here !/7 - People and Operating Costs/26 - The headcount plan and café staff hours.mp4 5.2 MB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/24 - Café cost of sales consumables and coffee at standard cost.mp4 5.1 MB
- ~Get Your Files Here !/1 - Welcome/1 - What you'll build.mp4 4.9 MB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/48 - Writing variance commentary managers actually read.mp4 4.0 MB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-13/s12-l64-final.xlsx 126.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/harbour-coffee-fy2027-model.xlsx 126.2 KB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/53 - s12-l64-final.xlsx 126.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-13/s12-l64-start.xlsx 125.9 KB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/53 - s12-l64-start.xlsx 125.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-12/s11-l62-final.xlsx 122.5 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/52 - s11-l62-final.xlsx 122.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-12/s11-l62-start.xlsx 122.3 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/52 - s11-l62-start.xlsx 122.3 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-12/s11-l61-final.xlsx 121.4 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/51 - s11-l61-final.xlsx 121.4 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-12/s11-l61-start.xlsx 120.9 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/51 - s11-l61-start.xlsx 120.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-12/s11-l60-final.xlsx 120.9 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/50 - s11-l60-final.xlsx 120.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-12/s11-l60-start.xlsx 120.6 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/50 - s11-l60-start.xlsx 120.6 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-12/s11-l59-final.xlsx 118.9 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/49 - s11-l59-final.xlsx 118.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-12/s11-l59-start.xlsx 117.5 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/49 - s11-l59-start.xlsx 117.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l57-final.xlsx 115.3 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/48 - s10-l57-final.xlsx 115.3 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l57-start.xlsx 114.8 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/48 - s10-l57-start.xlsx 114.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l56-final.xlsx 114.1 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/47 - s10-l56-final.xlsx 114.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l56-start.xlsx 113.9 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/47 - s10-l56-start.xlsx 113.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l55-final.xlsx 112.7 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/46 - s10-l55-final.xlsx 112.7 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l55-start.xlsx 111.5 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/46 - s10-l55-start.xlsx 111.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l54-final.xlsx 110.0 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/45 - s10-l54-final.xlsx 110.0 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l54-start.xlsx 108.7 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/45 - s10-l54-start.xlsx 108.7 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l53-final.xlsx 107.0 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/44 - s10-l53-final.xlsx 107.0 KB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/seaside-bakes-model-answer.xlsx 105.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Capstone/seaside-bakes-model-answer.xlsx 105.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l53-start.xlsx 104.9 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/44 - s10-l53-start.xlsx 104.9 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/s11-l63-practice-final.xlsx 102.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-12/s11-l63-practice-final.xlsx 102.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-12/s11-l63-practice-start.xlsx 99.7 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/s11-l63-practice-start.xlsx 99.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-10/s9-l51-final.xlsx 95.3 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/43 - s9-l51-final.xlsx 95.3 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/s10-l58-practice-final.xlsx 94.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l58-practice-final.xlsx 94.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-10/s9-l51-start.xlsx 94.8 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/43 - s9-l51-start.xlsx 94.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-10/s9-l50-final.xlsx 93.6 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/42 - s9-l50-final.xlsx 93.6 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-10/s9-l50-start.xlsx 93.4 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/42 - s9-l50-start.xlsx 93.4 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-10/s9-l49-final.xlsx 92.4 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/41 - s9-l49-final.xlsx 92.4 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-10/s9-l49-start.xlsx 92.1 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/41 - s9-l49-start.xlsx 92.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-11/s10-l58-practice-start.xlsx 90.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-10/s9-l48-final.xlsx 89.5 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/40 - s9-l48-final.xlsx 89.5 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/s10-l58-practice-start.xlsx 89.4 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-10/s9-l48-start.xlsx 89.2 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/40 - s9-l48-start.xlsx 89.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l46-final.xlsx 88.3 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/39 - s8-l46-final.xlsx 88.3 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l46-start.xlsx 87.7 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/39 - s8-l46-start.xlsx 87.7 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l45-final.xlsx 86.5 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/38 - s8-l45-final.xlsx 86.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l45-start.xlsx 85.9 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/38 - s8-l45-start.xlsx 85.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l44-final.xlsx 84.2 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/37 - s8-l44-final.xlsx 84.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l44-start.xlsx 82.9 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/37 - s8-l44-start.xlsx 82.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l43-final.xlsx 81.0 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/36 - s8-l43-final.xlsx 81.0 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l43-start.xlsx 80.1 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/36 - s8-l43-start.xlsx 80.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l42-final.xlsx 78.2 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/35 - s8-l42-final.xlsx 78.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l42-start.xlsx 76.8 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/35 - s8-l42-start.xlsx 76.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l40-final.xlsx 74.9 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/34 - s7-l40-final.xlsx 74.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l40-start.xlsx 74.7 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/34 - s7-l40-start.xlsx 74.7 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l39-final.xlsx 73.2 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/33 - s7-l39-final.xlsx 73.2 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/33 - s7-l39-start.xlsx 72.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l39-start.xlsx 72.5 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/s8-l47-practice-final.xlsx 71.6 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l47-practice-final.xlsx 71.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l38-final.xlsx 70.8 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/32 - s7-l38-final.xlsx 70.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l38-start.xlsx 70.1 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/32 - s7-l38-start.xlsx 70.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l37-final.xlsx 68.4 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/31 - s7-l37-final.xlsx 68.4 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l37-start.xlsx 67.6 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/31 - s7-l37-start.xlsx 67.6 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l36-final.xlsx 67.1 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/30 - s7-l36-final.xlsx 67.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l36-start.xlsx 67.0 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/30 - s7-l36-start.xlsx 67.0 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-09/s8-l47-practice-start.xlsx 66.7 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/s8-l47-practice-start.xlsx 66.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-07/s6-l34-final.xlsx 65.8 KB
- ~Get Your Files Here !/7 - People and Operating Costs/29 - s6-l34-final.xlsx 65.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-07/s6-l34-start.xlsx 65.7 KB
- ~Get Your Files Here !/7 - People and Operating Costs/29 - s6-l34-start.xlsx 65.7 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-07/s6-l33-final.xlsx 65.5 KB
- ~Get Your Files Here !/7 - People and Operating Costs/28 - s6-l33-final.xlsx 65.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-07/s6-l33-start.xlsx 64.6 KB
- ~Get Your Files Here !/7 - People and Operating Costs/28 - s6-l33-start.xlsx 64.6 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-07/s6-l32-final.xlsx 62.8 KB
- ~Get Your Files Here !/7 - People and Operating Costs/27 - s6-l32-final.xlsx 62.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-07/s6-l32-start.xlsx 60.8 KB
- ~Get Your Files Here !/7 - People and Operating Costs/27 - s6-l32-start.xlsx 60.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-07/s6-l31-final.xlsx 59.7 KB
- ~Get Your Files Here !/7 - People and Operating Costs/26 - s6-l31-final.xlsx 59.7 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-07/s6-l31-start.xlsx 58.6 KB
- ~Get Your Files Here !/7 - People and Operating Costs/26 - s6-l31-start.xlsx 58.6 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l41-practice-final.xlsx 58.2 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/s7-l41-practice-final.xlsx 58.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-06/s5-l29-final.xlsx 55.7 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/25 - s5-l29-final.xlsx 55.7 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-08/s7-l41-practice-start.xlsx 55.6 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/s7-l41-practice-start.xlsx 55.6 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-06/s5-l29-start.xlsx 54.7 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/25 - s5-l29-start.xlsx 54.7 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-06/s5-l28-final.xlsx 53.8 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/24 - s5-l28-final.xlsx 53.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-06/s5-l28-start.xlsx 53.4 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/24 - s5-l28-start.xlsx 53.4 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-06/s5-l27-final.xlsx 52.1 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/23 - s5-l27-final.xlsx 52.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-06/s5-l27-start.xlsx 51.7 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/23 - s5-l27-start.xlsx 51.7 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-06/s5-l26-final.xlsx 51.2 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/22 - s5-l26-final.xlsx 51.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-06/s5-l26-start.xlsx 50.8 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/22 - s5-l26-start.xlsx 50.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l24-final.xlsx 49.5 KB
- ~Get Your Files Here !/5 - The Revenue Budget/21 - s4-l24-final.xlsx 49.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l23-final.xlsx 49.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l24-start.xlsx 49.2 KB
- ~Get Your Files Here !/5 - The Revenue Budget/20 - s4-l23-final.xlsx 49.2 KB
- ~Get Your Files Here !/5 - The Revenue Budget/21 - s4-l24-start.xlsx 49.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-07/s6-l35-practice-final.xlsx 49.1 KB
- ~Get Your Files Here !/7 - People and Operating Costs/s6-l35-practice-final.xlsx 49.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l23-start.xlsx 48.8 KB
- ~Get Your Files Here !/5 - The Revenue Budget/20 - s4-l23-start.xlsx 48.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l22-final.xlsx 47.4 KB
- ~Get Your Files Here !/5 - The Revenue Budget/19 - s4-l22-final.xlsx 47.4 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l22-start.xlsx 47.4 KB
- ~Get Your Files Here !/5 - The Revenue Budget/19 - s4-l22-start.xlsx 47.4 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l21-final.xlsx 47.2 KB
- ~Get Your Files Here !/5 - The Revenue Budget/18 - s4-l21-final.xlsx 47.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-07/s6-l35-practice-start.xlsx 46.2 KB
- ~Get Your Files Here !/7 - People and Operating Costs/s6-l35-practice-start.xlsx 46.2 KB
- ~Get Your Files Here !/5 - The Revenue Budget/18 - s4-l21-start.xlsx 44.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l21-start.xlsx 44.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-06/s5-l30-practice-final.xlsx 41.1 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/s5-l30-practice-final.xlsx 41.1 KB
- ~Get Your Files Here !/5 - The Revenue Budget/17 - s4-l20-final.xlsx 40.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l20-final.xlsx 40.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-06/s5-l30-practice-start.xlsx 38.8 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/s5-l30-practice-start.xlsx 38.8 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/16 - s3-l18-final.xlsx 37.6 KB
- ~Get Your Files Here !/5 - The Revenue Budget/17 - s4-l20-start.xlsx 37.6 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-04/s3-l18-final.xlsx 37.6 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l20-start.xlsx 37.6 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/16 - s3-l18-start.xlsx 37.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-04/s3-l18-start.xlsx 37.5 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/15 - s3-l17-final.xlsx 36.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-04/s3-l17-final.xlsx 36.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-04/s3-l17-start.xlsx 35.1 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/15 - s3-l17-start.xlsx 35.1 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l25-practice-final.xlsx 34.9 KB
- ~Get Your Files Here !/5 - The Revenue Budget/s4-l25-practice-final.xlsx 34.9 KB
- ~Get Your Files Here !/5 - The Revenue Budget/3 - Quiz the revenue budget.html 34.7 KB
- ~Get Your Files Here !/3 - How Budgeting Works in a Real Company/2 - Quiz how budgeting works.html 34.4 KB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/1 - Quiz the accounting you need.html 32.9 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/4 - Quiz production, inventory and cost of sales.html 31.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/harbour-coffee-company-pack.xlsx 31.9 KB
- ~Get Your Files Here !/7 - People and Operating Costs/5 - Quiz people and operating costs.html 31.1 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/13 - s3-l15-final.xlsx 29.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-04/s3-l15-final.xlsx 29.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-05/s4-l25-practice-start.xlsx 29.4 KB
- ~Get Your Files Here !/5 - The Revenue Budget/s4-l25-practice-start.xlsx 29.4 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/13 - s3-l15-start.xlsx 28.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-04/s3-l15-start.xlsx 28.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-04/s3-l19-practice-final.xlsx 25.5 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/s3-l19-practice-final.xlsx 25.5 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-04/s3-l19-practice-start.xlsx 23.8 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/s3-l19-practice-start.xlsx 23.8 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/6 - Quiz working capital, capex and funding.html 22.8 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/7 - Quiz scenarios, sensitivity and decisions.html 22.5 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/8 - Quiz forecasting and the reforecast.html 22.2 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Capstone/seaside-bakes-company-pack.xlsx 19.9 KB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/seaside-bakes-company-pack.xlsx 19.9 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-02/s1-l08-practice-final.xlsx 7.8 KB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/7 - s1-l07-final.xlsx 7.8 KB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/s1-l08-practice-final.xlsx 7.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-02/s1-l07-final.xlsx 7.8 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-02/s1-l08-practice-start.xlsx 7.3 KB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/s1-l08-practice-start.xlsx 7.3 KB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/7 - s1-l07-start.xlsx 7.3 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/Udemy-Section-02/s1-l07-start.xlsx 7.3 KB
- ~Get Your Files Here !/3 - How Budgeting Works in a Real Company/8 - What FP&A does all year the planning calendar.en_US.srt 6.0 KB
- ~Get Your Files Here !/3 - How Budgeting Works in a Real Company/11 - Driver-based budgeting the few numbers that drive everything.en_US.srt 5.8 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/15 - The assumptions sheet named inputs, scenario columns and a CHOOSE switch.en_US.srt 5.5 KB
- ~Get Your Files Here !/3 - How Budgeting Works in a Real Company/12 - The master budget map which schedule feeds which.en_US.srt 5.1 KB
- ~Get Your Files Here !/3 - How Budgeting Works in a Real Company/9 - Budget vs forecast vs plan vs target.en_US.srt 5.1 KB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/7 - Reading the trial balance and mapping it to the statements.en_US.srt 4.7 KB
- ~Get Your Files Here !/3 - How Budgeting Works in a Real Company/10 - Top-down vs bottom-up (and the negotiation in between).en_US.srt 4.7 KB
- ~Get Your Files Here !/5 - The Revenue Budget/18 - Bottom-up café revenue covers x average ticket, café by café.en_US.srt 4.3 KB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/4 - Three statements, one business a café day.en_US.srt 4.3 KB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/54 - Telling the story three messages for the board.en_US.srt 4.3 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/13 - Model layout inputs, calculations, outputs and one timeline.en_US.srt 4.1 KB
- ~Get Your Files Here !/1 - Welcome/3 - Meet Harbour Coffee Co. cafés, roastery, and the FY2027 brief.en_US.srt 3.7 KB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/5 - Profit is not cash accruals, inventory and timing.en_US.srt 3.7 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/Practice Seaside Bakes' working capital, capex, loan and sales tax.html 3.5 KB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/6 - How the statements link retained earnings, cash, working capital.en_US.srt 3.4 KB
- ~Get Your Files Here !/1 - Welcome/1 - What you'll build.en_US.srt 3.4 KB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/55 - Optional using AI to draft commentary and audit a model, safely.en_US.srt 3.3 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/22 - Roastery production budget sales + closing stock - opening stock.en_US.srt 3.3 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/16 - The checks sheet one place that proves the model adds up.en_US.srt 3.3 KB
- ~Get Your Files Here !/5 - The Revenue Budget/Practice build Seaside Bakes revenue.html 3.2 KB
- ~Get Your Files Here !/5 - The Revenue Budget/17 - Analysing two years of actuals seasonality and revenue mix.en_US.srt 3.2 KB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/Capstone Seaside Bakes end to end.html 3.1 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/Practice Seaside Bakes' bakery production and cost of sales.html 3.1 KB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/56 - Wrap-up what you can do now, and where FP&A careers go next.en_US.srt 3.1 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/35 - Budgeted income statement and the income tax schedule.en_US.srt 3.1 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/Practice set up the Seaside Bakes model shell.html 3.0 KB
- ~Get Your Files Here !/7 - People and Operating Costs/Practice Seaside Bakes' payroll and operating costs.html 3.0 KB
- ~Get Your Files Here !/2 - The Accounting You Need (and No More)/Practice map Seaside Bakes' trial balance to the statements.html 2.8 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/Practice Seaside Bakes' June close BvA, PVM, cost variances, commentary.html 2.8 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/36 - Budgeted balance sheet making it balance (and finding why it doesn't).en_US.srt 2.8 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/31 - The working-capital budget debtors, stock and creditors by month.en_US.srt 2.8 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/Practice Seaside Bakes statements, KPIs and one-page summary.html 2.8 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/Practice Seaside Bakes reforecast and bridges.html 2.8 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/44 - Loading monthly actuals the data tabs and the Actuals sheet.en_US.srt 2.7 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/37 - Budgeted cash flow, indirect method, and the minimum cash test.en_US.srt 2.7 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/51 - The mid-year reforecast run-rates, the late opening, costs and payroll.en_US.srt 2.7 KB
- ~Get Your Files Here !/1 - Welcome/2 - How to use this course + download the files.en_US.srt 2.7 KB
- ~Get Your Files Here !/4 - Building a Model People Can Trust/14 - Formatting conventions blue inputs, black formulas, green links.en_US.srt 2.6 KB
- ~Get Your Files Here !/7 - People and Operating Costs/28 - Operating costs fixed, variable and step costs.en_US.srt 2.6 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/33 - Loan schedule drawdown, interest, repayments and covenants.en_US.srt 2.6 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/45 - BvA report month, YTD, favourable adverse and materiality.en_US.srt 2.6 KB
- ~Get Your Files Here !/5 - The Revenue Budget/20 - Wholesale revenue customers, kilos and price per kilo.en_US.srt 2.6 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/25 - Inventory valuation and the cost of sales summary.en_US.srt 2.6 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/32 - Capex plan, fixed asset rollforward and depreciation.en_US.srt 2.5 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/23 - The materials budget green beans, roast loss, packaging and energy.en_US.srt 2.5 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/46 - Price, volume and mix variance for café revenue.en_US.srt 2.5 KB
- ~Get Your Files Here !/5 - The Revenue Budget/21 - The new café Harbour Quay's ramp-up from its opening month.en_US.srt 2.5 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/42 - Break-even per café and for the roastery.en_US.srt 2.5 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/43 - Store #13 go no-go NPV, IRR and payback.en_US.srt 2.4 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/40 - Base, upside, downside one switch, three versions of the year.en_US.srt 2.4 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/47 - Cost variances rate vs efficiency on labour and beans.en_US.srt 2.4 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/38 - KPI page margins, EBITDA, cash and covenant headroom.en_US.srt 2.4 KB
- ~Get Your Files Here !/10 - Scenarios, Sensitivity and Decisions/41 - Sensitivity analysis and a tornado chart.en_US.srt 2.4 KB
- ~Get Your Files Here !/7 - People and Operating Costs/29 - Allocating head office costs to regions.en_US.srt 2.2 KB
- ~Get Your Files Here !/7 - People and Operating Costs/27 - Payroll wages, salaries, the July pay rise and on-costs.en_US.srt 2.2 KB
- ~Get Your Files Here !/13 - The Board Pack (Capstone)/53 - One-page FP&A dashboard KPIs, BvA, forecast and cash.en_US.srt 2.2 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/30 - Cash conversion cycle debtor, inventory and creditor days.en_US.srt 2.1 KB
- ~Get Your Files Here !/6 - Production, Inventory and Cost of Sales/24 - Café cost of sales consumables and coffee at standard cost.en_US.srt 2.1 KB
- ~Get Your Files Here !/7 - People and Operating Costs/26 - The headcount plan and café staff hours.en_US.srt 2.1 KB
- ~Get Your Files Here !/9 - The Integrated Master Budget/39 - Sign-off presenting the budget to the CEO on one page.en_US.srt 1.9 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/52 - EBITDA and cash bridges from budget to reforecast.en_US.srt 1.9 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/50 - FORECAST.ETS a statistical forecast vs driver judgement.en_US.srt 1.9 KB
- ~Get Your Files Here !/5 - The Revenue Budget/19 - Top-down check management's target vs the bottom-up build.en_US.srt 1.7 KB
- ~Get Your Files Here !/12 - Forecasting and the Reforecast/49 - Latest estimate actuals to date plus budget, one timeline.en_US.srt 1.6 KB
- ~Get Your Files Here !/8 - Working Capital, Capex and Funding/34 - Sales tax timing cash you collect but don't own.en_US.srt 1.6 KB
- ~Get Your Files Here !/11 - Month-End Budget vs Actual/48 - Writing variance commentary managers actually read.en_US.srt 1.6 KB
- ~Get Your Files Here !/1 - Welcome/FPA-in-Excel-course-files/README.txt 851 bytes
- Get Bonus Downloads Here.url 180 bytes
- ~Get Your Files Here !/Bonus Resources.txt 70 bytes
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.