Budgeting & Forecasting
-
Budgeting for release of resricted funds
I am struggling with how to present the budget for my nonprofit employers. With respect to releasing restricted funds that were recorded as revenue in a previous year, for a project to be done next year. We use Quickbooks and are a bit constrained on how we can present. We aren't set up for a t…
1
-
12 month software license renewal over more than one FY
Hello, I renew many software license agreements during the fiscal year. These agreements are due for renewal at various time of the year and most are 12 month renewals. In case it matters, this is for a non-profit University. We recently found out that Accounting has been pulling funds for …
2
-
When forecasting financial models in excel, how do you make the timing of cashflows dynamic?
I am building a financial model for my company right now. We are a medical device company, so regulatory approvals timing has the ability to dramatically effect when cashflows are expected to occur. I want to add an assumptions tab, where I will include "Months until reg approval." Based on this…
-
Looking for a standard chart of accounts for a medical device that manufactures it's devices onsite
We are working on an engagement in the medical device sector (orthopedics) and need of a standard chart of accounts for this industry with light manufacturing in house in order to benchmark. Any and all guidance would be appreciated.
-
Proper set up and recording of transactions in government program budgeting tool
I work in the Financial Management department of a U.S. government agency. We use a MS Excel-based budgeting tool with which we record allocations of and expenditures from program budgets. In addition to budget allocations and expenditures, I need to incorporate in this tool the recording of prog…
4
-
Business case help - recognising revenue paid over 24 months
hi im stuck on a business case I’m doing at work (retail business). So it’s selling a product that costs us £100 and customers will pay £10 a month for over 24 months - I’ve got to business case the numbers for first 6 months, then a full year after. So, volumes are expected to be 1000 sales a m…
2
-
MD designation on Healthcare Finance Manager Job Resume'/application
I need career advice from experts if I may. BACKGROUND: I came to USA as an MD and was not able to get into medical residency to pursue my career as an MD. I decided to go into the Healthcare Administration sector and ended up working as a Grants Financial Analyst in the healthcare setup. I hav…
3
-
Allocating fixed costs when unsure about how much product will be sold
I’m an intern at a small publishing company, and I’ve been tasked with finding out the cost of each product to ultimately create a costing model and to calculate profitability of each product. We have a large number of products, and each product takes some amount of money to initially create (grap…
3
-
What are your top pain points around budgeting and forecasting?
Need to better understand the top pain points around the planning and reporting process (generally FP&A) outside of my own experience. What are your biggest pain points? For example, for me it has always been: - Headcount reconciliation, approvals, & planning - Data cleansing (e.g. g…
-
Cost Allocation: split 50% on headcount and 50% on revenue
Have you heard of cost allocation on this basis in management accounts and how should it work? This is to allocate revenue to each business line
1
-
Sales Forecasting for Startup - how to structure it when mixing turnover/margin units/unit price
Hey all, I am currently struggling trying to figure out how to best structure my sales forecast. A small part of our business we have a fixed unit price and a goal for how many we want to sell of each per month at a predefined unit price. The main part of our business however is turnover based w…
-
Where can I find posted budget vs actual reports from other companies?
Hi, I just registered with this site in hopes of gaining a resource that I can pull from. I work as an accountant in a small business and help with the internal duties surrounding accounting. I report to our controller/VP Finance. They have produced a budget for 2018, and we have also put togeth…
1
-
Accounting for Sales Commission
**BACKGROUND** We are an enterprise-SaaS startup; our Sales Contracts are typically multi-year agreements. **ASSUME** * Sales person closes a 3-year contract with Total Contract Value (TCV) = 300k * Sales person commission is 10% **QUESTIONS** 1) At the time the Sales Contract is …
1
-
Does any one know how to calculate the revenue need for net income on a certain GM%
I am working on a budget for next year need to figure out what is the revenue requirement for each GM and net income. For example, operating expense % over revenue is at 27% and GM is at 27%. For Net income of $1000, how much revenue require? If the GM is 1% lower which is at 26%, operating ex…
5
-
Excel Question
Hello- Would you please let me know if there is a way by using excel function to pull: 1) invoices from a string of texts below? 2) Invoices related to the associated companies only? i.e. I would like to pull only invoice started with CO#3 and disregard the all others sales order from different cos…
4
-
Headcount Forecast In Excel
I have a headcount forecasting worksheet in workbook an ex-employee left behind that has some holes in it. I need a formula in Excel that populates a headcount grid by querying the cells for each employee's start date, and also a formula for allowing for percentage raises . Any brilliant Excel mode…
9
-
How to assess Excel and data management skills in a job interview
Excel and data management (including working with large volumes of data and databases) skills are often assumed upon finance and accounting professionals. However, some positions are better served by those who are exceptionally strong in this area. How does a hiring manager assess (or maybe offer a…
17
-
Creating an overdraft facility in Excel financial model
I need to create an overdraft facility or variable loan so that the amount of the loan varies monthly according to the requirements of the business. When I create a formula in Excel to calculate the interest on the loan needed for the current month it creates an error message and is circular. This …
8
