Skip to content

Personal Blog of Satrio

Menu
  • Portfolio
  • Privacy Policy
Menu

Master Budget Modeling

Posted on October 13, 2019January 5, 2021 by Satrio

It was a task given by my lecturer when I was at Management Accounting Class. The problem is taken from my class’s reference book: Management Accounting by Hansen/Mowen. At that time, i did not know what modeling is, I just used basic excel formulas and referring cell in one sheet to another. these are my reworked master budget modeling since I did not apply good modeling practices in my first work. I used blue and yellow Corporate Finance Institute  Excel Color Theme.

 

Dashboard

What is new:
  • Different font color for input, output, and data which is taken from other sheet(s)
  • Consistent color theme
  • All budget modeling was built in one sheet, the dashboard and supporting calculation have their own sheet
  • Add: One page simple dashboard with a basic chart and graph

 

Master Budget


Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Protected: Explore Candi Jawa Tengah
  • Notes on The Kingship of Self Control by William George Jordan
  • Sido Muncul Dividend Discount Model Valuation
  • Charles Bukowski : Puisi Pilihan Terbaik
  • Walmart Discounted Cash Flow Valuation

Categories

  • Biography
  • Business
  • Economics
  • Fintech
  • Hobby
  • Portfolio
  • Review

Archives

  • August 2021
  • July 2021
  • March 2021
  • February 2021
  • October 2020
  • May 2020
  • March 2020
  • November 2019
  • October 2019
  • September 2019
  • April 2018
  • March 2018
  • February 2018

Industrious

Art of Wasting No Time

Pale Blue Dot

A Reminder on How Insignificant We Are

© 2022 Personal Blog of Satrio | Powered by Superbs Personal Blog theme