Financial Plan - Assumptions-1

I received a comment from a Planware representative about their Excel-based products dealing with Financial projections and Business Plans. I checked out their website, they have some wonderful products, which may be used as a model for building the plan and creating projections. You will see some of those projections being used in our plan too.

Before we start with an actual Financial plan, there is a need to make some Assumptions. These assumptions will put the plan in proper perspective leaving no doubts in the mind of Venture Capitalists, when they read the plan projections. In assumptions area, you clearly get to specify average values, opening balances, percentages, tax rates and some ratios.As a start-up business, we will have very few variables that we can state in our assumptions list. I will build a template here and fill in the values tomorrow. Not all variables will be filled, as we are a service organization.

VariablesUnitsFirst YearSecond Year3-5 Years
Average Monthly SalesUS $000s
Desired average finished inventory% of Sales
Cost of materials/goodsAs % Sales
Target materials/goods inventoryUS $000s
Average monthly direct costs US $000s
Average monthly overhead expensesUS $000s
Opening total cost of fixed assetsUS $000s
Accumulated opening depreciationUS $000s
Average depreciation rate% p.a.
Planned capital expenditure for yearUS $000s
Interest rate for cash balances% p.a.
Interest rate for all debt/notes% p.a.
Opening cash balance (deficit)US $000s
Opening longterm debt/notesUS $000s
Net change in longterm debt/notes in yrUS $000s
Opening accounts receivableUS $000s
Opening accounts payableUS $000s
Average credit given on salesDays Sales
Average credit taken for materials/goodsDays Sales
Expected federal/state tax rate%
Planned dividend for yearUS $000s
Opening number of shares000s
Proceeds of new stock issuesUS $000s
Number of new shares issued000s


Comments

Post a Comment

Popular posts from this blog

Financial Plan - Assumptions - 2

There is a slight change since yesterday. I will not fill the Assumption table in yesterday's post. Instead, I will discuss what each variable means. This way table is more meaningful, rather than mere numbers. Variables_Used_for_Assumption Units_Used Explanation_of_Variables Average Monthly Sales US $000s Here you can enter net sales value. Desired average finished inventory % of Sales Does not apply to Service / Distribution business. For Manufacturing business, this variable is % of sales. Cost of materials/goods As % Sales This value is set to zero for Service business and for Distribution it refers to the purchases/inventory for resale. Target materials/goods inventory US $000s This value is set to zero for Service business and for Distribution it refers to the purchases/inventory for resale. Average monthly direct costs US $000s It is set to zero for for Distribution business Average monthly overhead expenses US $000s Interest and Depreciation is not included Opening total co...
Read more

The Circle of Information

First there was light, then there was a Light Bulb controlled by a switch, then came Internet and the light bulb was still controlled by a switch, finally Pervasive internet will come and control the Light Bulb. This is the vision of Pervasive Internet. This next version of Internet is destined to control : * Industrial - Capital Equipment, Automation & Control Equipment * Power - Meters, Distributed Generators, Electricity Grid and Pipelines * Healthcare - Medical Devices * Home / Consumer - Game Systems, Consumer Electronics, Appliances * Buildings / Facilities - Access Controls, Office Equipment, HVAC / Environmental Systems * Retail - Lighting & Refrigeration Systems, Scanners & Registers * Transportation - Vehicles, Airplanes, & Intermodal Transport This congregation of Internet with the smart devices will create a serious shift in the advancement of the digital revolution - forming a comprehensive "digital neural net". Imagine a large office building in ...
Read more

Brainstorming - RFID Discussion

Radio Frequency ID tags or RFID Tags came into limelight when Walmart insisted their suppliers to have them by January 1st 2005. RFIDs have existed for few years and are used as security devices on Music CDs, Games CDs and DVDs and various other areas. There are however many unexplored areas where RFID solutions can be used. We are going to explore some of these areas for potential product and/or services that Businessworks Inc can provide. If we go with RFID based solutions, manufacturing RFIDs will not our goal as it can be prohibitively expensive. Our goal would consist of using RFIDs readily available and building custom solutions and sell it to Government and private organizations. This idea ranks very high in our potential list of technologies. Tomorrow I will discuss Nanotechnology.
Read more