more-arw search

Topics

Anonymous Member
Anonymous
(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 Healthcare Administration sector and ended up working as a Grants Financial Analyst in the...
Anonymous Member
Anonymous
(B) 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...
Member's Profile
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
Anonymous Member
Anonymous
(CFO) 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 -...
Anonymous Member
Anonymous
(Entrepreneur) 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...
Member's Profile
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 accounting. I report to our controller/VP Finance. They have produced a budget for 2018, and...
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 my time spent on the Microsoft Excel team way back in 1991. (Yes, I know you were not born yet...
Anonymous Member
Anonymous
(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 Contract Value (TCV) = 300k * Sales person commission is 10% **QUESTIONS** 1) At the time the Sales...
Member's Profile
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 at 27%. For Net income of $1000, how much revenue require? If the GM is 1% lower which...
Member's Profile
Roger Frederick
Title: CFO
Company: Private
(CFO at Private)
Anonymous Member
Anonymous
(Financial Reporting Manager) Has anyone used the Vena Solutions for Budgeting or Reporting? Thoughts?
Anonymous Member
Anonymous
(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.e. I would like to pull only invoice started with CO#3 and disregard the all others sales...
Member's Profile
Christopher Webb
Title: Accounting Manager
Company: Private
(Accounting Manager at Private)
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, etc.
Member's Profile
Fletcher Riehl
Title: Owner
Company: Consulting COO
LinkedIn Profile
(Owner at Consulting COO) Does anyone use Excel on a Macbook Pro? I'm an old pro on PCs, but I'm tired of carrying around two computers or running Windows on my Mac. Has anyone had success building financial models on a Mac OS running Excel? Are there any great macros/custom shortcut setup...
Member's Profile
Sheldon Reynolds
Title: CFO
Company: Private
(CFO at Private) Obviously the more advanced tools (like pivot tables and macros) are Excel only, but for basic spreadsheets, is Google on par with Excel?
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO at SBAConsulting.com) From time to time I'll throw out a term that I see constantly used. How would you a) define the term (meaning) and then better explain it so most readers would understand what you want. This could be fun... Advanced Pivot Table
Charley Kyd
Title: Founder
Company: ExcelUser
(Founder at ExcelUser) Excel blogs are filled with specific questions about using Excel. So I thought it might be useful to back up and ask a more general question: What types of spreadsheet tasks are causing particular problems at your company, and why? Where do you or your Excel co-workers...
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO at SBAConsulting.com) Here's a question that can be very entertaining and educational for all. Excel, every white and many blue collar workers needs to know how to use the product to successfully integrate into today's business world. "How to use" is obviously very subjective,...