more-arw search

Q&A Forum

When forecasting financial models in excel, how do you make the timing of cashflows dynamic?

Robert Green
Title: Cofounder & COO
Company: Amina Health
(Cofounder & COO at Amina Health)
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 expec...
124 Views | 0 Answers/Comments

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 ea...
2772 Views | 1 Answers/Comments

Looking for a standard chart of accounts for a medical device that manufactures it's devices onsite

(Managing Consultant)
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 bench...
1194 Views | 0 Answers/Comments

what is the best practical book in budgeting and reporting for beginners ?

Hessa Mb
Title: Professional
Company: Etisalat Company
(Professional at Etisalat Company)
1394 Views | 0 Answers/Comments

Proper set up and recording of transactions in government program budgeting tool

E. Stephen Kim
Title: Financial Management Analyst
Company: U.S. Department of Defense
(Financial Management Analyst at U.S. Department of Defense)
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 budg...
1763 Views | 4 Answers/Comments

Business case help - recognising revenue paid over 24 months

Candi Bell
Title: Finance manager
Company: Retail
(Finance manager at Retail)
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...
1963 Views | 2 Answers/Comments

MD designation on Healthcare Finance Manager Job Resume'/application

(Financial Analyst)
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 ...
2344 Views | 3 Answers/Comments

Cost Allocation: split 50% on headcount and 50% on revenue

Sylwia Karpinska
Title: Financial Controller
Company: CFG
(Financial Controller at CFG)
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
2034 Views | 1 Answers/Comments

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 exampl...
2272 Views | 0 Answers/Comments

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 ...
1750 Views | 0 Answers/Comments

Where can I find posted budget vs actual reports from other companies?

Steve Cannell
Title: Senior Accountant
Company: Private
(Senior Accountant at Private)
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 ac...
2926 Views | 1 Answers/Comments

Back in the Day...

Nancy Tso
Title: Head of Client Service
Company: SkyStem
(Head of Client Service at SkyStem)
Here is a story of what people used to do with Excel, back in the day… (here’s the full article) Forgive me if I now divert into telling you a quick story about ...
4167 Views | 2 Answers/Comments

Accounting for Sales Commission

(Director of Finance and Operations)
**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 Contrac...
2874 Views | 1 Answers/Comments

Does any one know how to calculate the revenue need for net income on a certain GM%

Lindsay Ho
Title: Accounting Manager
Company: Calypto Design Systems
(Accounting Manager at Calypto Design Systems)
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 ...
2792 Views | 5 Answers/Comments

What are the Limits of Excel as a Project Management Tool?

Roger Frederick
Title: CFO
Company: Private
(CFO at Private)
9811 Views | 12 Answers/Comments

Vena Solutions

(Financial Reporting Manager)
Has anyone used the Vena Solutions for Budgeting or Reporting? Thoughts?
1200 Views | 0 Answers/Comments

Using my current profit and loss ststement how would I figure out next years needs, labor cost and supplies?

(Analyst II)
2042 Views | 1 Answers/Comments

Excel Question

(Senior Accountant)
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....
4031 Views | 4 Answers/Comments

Is there a way to collaborate with someone on a Microsoft Excel spreadsheet in real-time?

Christopher Webb
Title: Accounting Manager
Company: Private
(Accounting Manager at Private)
101030 Views | 19 Answers/Comments

How to make a sortable table in email

Gary Zeune
Title: Managing Director
Company: The Pros & The Cons
LinkedIn Profile
(Managing Director at The Pros & The Cons)
I need to include a table with prox 100 rows and 5 columns in html email. How do I create it so that people can click on the column top, header, row to sort by that column? Col 1, Col 2...
3546 Views | 0 Answers/Comments

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.