
Build excel spreadsheet with Forecasting
- or -
Post a project like this162
$175
- Posted:
- Proposals: 35
- Remote
- #4406359
- Awarded
PPH TOP Web Developer | Digital Marketing (SEO, Social Media Management, Facebook/Instagram Ads, Google Ads)|WordPress, Shopify, Wix, e-commerce, | Video Editing

Business Analyst | Data Collection | Web Researcher | PowerPoint Presentation Expert

7+ years in Data Insights: Excel | Google Sheets | Power BI | Python | SQL | Data Scraping
Delivering High-Quality IT Services at Competitive Prices |Experienced Full Stack Web and App Developer |Android and IOS App Development|


Financial & Business Strategy Expert | Business Plan, Pitch Deck, and Financial Modelling Specialist

UK Chartered Accountant (ACA)/ FCCA / IFRS and reporting specialist / Excel expert / Xero Advisor

345103010749830198242767075181179020611555813123708421193508848997843276695213850611946305
Description
Experience Level: Intermediate
This project requires developing an intricate Excel spreadsheet with advanced forecasting capabilities. The spreadsheet needs to allow for scenario modeling where key inputs like sales figures, expenses, and growth rates can be modified to analysis different outcomes. The interface should be intuitive for non-technical users to understand yet robust enough for number crunchers to extract insightful data. Specifically, the spreadsheet needs to forecast income statements, balance sheets and cash flow statements for the next 3 years based on monthly projections. It needs to automatically pull in historical financials from the past 2 years for benchmarking purposes. Formulas calculating key metrics like EBITDA, operating margin, net income etc need to be integrated. Conditional formatting showing variances between base case and what-if scenarios is vital. Pivots and charts visualizing the implications of input tweaks on important KPIs over time must feature prominently. Finally, the file has to be designed for sharing within an organization, so well-organized sheets with descriptive names and titles are paramount alongside help documentation. Only bids demonstrating expertise developing sophisticated Excel models with forecasting at their core will be considered.
Natasha A.
100% (8)Projects Completed
5
Freelancers worked with
6
Projects awarded
58%
Last project
8 Aug 2023
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-

Hi Natasha, Are you available now to talk?
-

Sorry, Natasha
-

What are you trying to model Natalie?
113563111355961135586
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies