Corporate Finance #3 Forecasting & Budgeting

Learn how to forecast and budget from a certified public accountant (CPA)

4.42 (118 reviews)
Udemy
platform
English
language
Management
category
Corporate Finance #3 Forecasting & Budgeting
33,960
students
8.5 hours
content
Oct 2022
last update
$84.99
regular price

What you will learn

Forecasting objectives

How to construct a budget

How to create a proforma income statement

How to create a cash budget

Ho to make a proforma balance sheet

How to use a percent of sales method

Description

This course will cover the concepts of forecasting and budgeting from a finance perspective.

The course includes many example problems, both in presentation form, and many using Excel worksheets. Each Excel worksheet problem will include a downloadable Excel worksheet that has at least two tabs, one having the answer, the second including a preformatted worksheet that can be populated in a step-by-step process along with the instructional video.

To forecast and budget we need to make predictions and projections about the future. This is often done by first taking information from the past as our starting point. The starting point will generally be our prior financial statements, including our prior balance sheet, income statement, and statement of cash flows.

We will then consider changes that we expect to take place, including those we plan on making and changes to the economy and business environment.

When constructing our budgets will need to go in a systematic order. We usually need to start with a sales projection because other projections will depend on it.

Our budget process can then consider the production plan. We can then move to the capital budget, cash budget, and budgeted income statement. The budgeted income statement is our primary performance statement.

Once we have the beginning balance sheet and the projected income statement, we can create the projected balance sheet, the statement representing where we expect to be at the end of the budgeted time frame.

Content

Introduction

405 Forecasting Objectives
410 Pro Forma Income Statement
415 Cash Budget
420 Pro Forma Balance Sheet
425 Percent of Sales Method

Practice Probs - Forecasting & Budgeting

414 Sales Projection – Multiple Scenarios
416 Estimated Net Sales
418 Projected Units to be Produced
423 Calculate Cost of Goods Sold Using FIFO & LIFO
424 Calculate Cost of Ending Inventory LIFO & FIFO
427 Schedule of Cash Receipts
428 Schedule of Cash Receipts – Multiple Scenarios
430 Schedule of Cash Payments
431 Schedule of Cash Payments – More Complex
432 Production Schedule & Schedule of Cash Payments
434 Cash Budget & Cash Receipts Schedule
435 Cash Budget, Cash Receipts Schedule, Cash Payments Schedule
437 Required New Fund Formula All Balance Sheet Accounts Change Relative to Sale
438 Required New Fund Formula – Current Assets & Liabilities Change Relative to

Excel Probs - Forecasting & Budgeting

414 Sales Projection – Multiple Scenarios
416 Estimated Net Sales
418 Projected Units to be Produced
421 Calculate Cost of Goods Sold Using FIFO
423 Calculate Cost of Goods Sold Using LIFO & FIFO
427 Schedule of Cash Receipts
428 Schedule of Cash Receipts – Multiple Scenarios
430 Schedule of Cash Payments
431 Schedule of Cash Payments – More Complex
432 Production Schedule & Schedule of Cash Payments
434 Cash Budget & Cash Receipts Schedule
435 Cash Budget, Cash Receipts Schedule, Cash Payments Schedule
436 Cash Receipts, Cash Payments, & Cash Budget
437 Required New Fund Formula – All Balance Sheet Accounts Change Relative to Sa
438 Required New Fund Formula – Current Assets & Liabilities Change Relative to

Reviews

David
October 2, 2022
This Is a very beneficial course. I highly recommend it for students and practitioners in the field of finance. I'm so happy, as my expectations were met, and even beyond. Once again, thank you.
Eletu
September 22, 2022
Yes, it was a good match. Recently I joined a Sales Company and I can happily say this is helpful in our Department and it has widened my horizon .Thank you
Nasir
October 3, 2021
It was an Amazing Presentation by the speaker and huge applause to him, he explained everything in forecasting and budgeting as good as all his presentation that i attended so for in this courses, So Thank you for the 3 courses of corporate finance, I will look for similar courses that resembles the forms in accounting.

Coupons

DateDiscountStatus
6/11/2021100% OFF
expired
6/26/202194% OFF
expired
7/13/2021100% OFF
expired
8/19/2021100% OFF
expired
9/15/2021100% OFF
expired
10/14/2021100% OFF
expired
11/28/2021100% OFF
expired
12/16/2021100% OFF
expired
1/24/2022100% OFF
expired
2/6/2022100% OFF
expired
2/13/2022100% OFF
expired
2/23/2022100% OFF
expired
3/7/2022100% OFF
expired
3/14/2022100% OFF
expired
4/11/2022100% OFF
expired
4/19/2022100% OFF
expired
5/14/2022100% OFF
expired
5/20/2022100% OFF
expired
6/16/2022100% OFF
expired
7/7/2022100% OFF
expired
8/5/2022100% OFF
expired
8/10/2022100% OFF
expired
8/20/2022100% OFF
expired
9/10/2022100% OFF
expired
9/21/2022100% OFF
expired
10/4/2022100% OFF
expired
10/11/2022100% OFF
expired
10/17/2022100% OFF
expired
11/5/2022100% OFF
expired
12/5/2022100% OFF
working

Charts

Price

Corporate Finance #3 Forecasting & Budgeting - Price chart

Rating

Corporate Finance #3 Forecasting & Budgeting - Ratings chart

Enrollment distribution

Corporate Finance #3 Forecasting & Budgeting - Distribution chart
3939426
udemy ID
3/26/2021
course created date
6/11/2021
course indexed date
Angelcrc Seven
course submited by