Jason Varnersmarthelping.com - Freelancer - I make my living working in Excel and G-sheets. Follow 87
- views 18k
- users 258
- reviews 24
- Downloadable Tools 56
Jason Varner
smarthelping.com - Freelancer - I make my living working in Excel and G-sheets.
Follow 87
Hire Me!
Graduated with a major in Accounting back in 2011. My career took some twists and turns from there. I ended up getting into freelancing and building real estate models. From there I built up skills in automated tracking and reporting as well as fine tuning my financial modeling skills will all kinds of business logic.
TagsWebsiteSocial
Categories
Industry Specific Financial Models
Startup Financial Models
Financial Projections Models
Real Estate Finance
Inventory Management
Logistics & Supply Chain Management
Venture Capital
Personal Finance
Cash Flow
Software-as-a-Service (SaaS)
Sales
Marketplaces
Discounted Cash Flow (DCF)
Income Statement
KPI Dashboards
Human Resources
Retail Finance
Amortization & Depreciation Schedule
Finance
Sensitivity Analysis
Manufacturing
Automotive Business
Customer Acquisition
Project Management
Agriculture Finance
Mining Financials
Productivity
Marketing
Restaurant Finance
Three Statement Financial Models
Balance Sheet
Corporate Finance
Mobile App Finance
Waterfall Charts
Debt Schedule
Loan Amortization
Break-Even Analysis
Freemium
Mobile App / Website - 5 Year Recurring Revenue Excel Model Template
A financial forecasting excel model template for apps or websites that have recurring paid subscribers.1,280Discussadd_shopping_cart$95.00Used Car Dealership - 5 Year Pro-Forma Excel Financial Model
A bottom up financial model to forecast the revenue, expenses, and cash flows of a used car dealership startup business.1,014Discussadd_shopping_cart$45.00Inventory Tracking Excel Template - Multiple Locations
Manage inventory that moves back and forth between multiple locations (up to 21).1,486Discussadd_shopping_cart$45.00Orchard (Apple or Otherwise) Excel Financial Model
Bottom-up financial projections for an orchard (apple or otherwise).189Discussadd_shopping_cart$45.00Golf Course - Startup Excel Financial Model
A financial model template designed to improve your golf course business plan.1704add_shopping_cart$95.005-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
A straight forward approach to build financial projections for a SaaS startup business.1,5782add_shopping_cart$45.00KPI Tracking Excel Template
A template that shows some structured columns about sales of various skus and how that can be used for KPI tracking.924Discussadd_shopping_cartfreeNetwork/Marketplace Startup 5-Year Financial Model with Cap Table
Plan out the assumptions for a startup network and see what the 5-year forecast looks like.343Discussadd_shopping_cart$45.00Fitness Center/Gym: Startup Financial Model - 10 Year
A tool to help forecast the cash flow and cash requirement of starting a gym or fitness center.625Discussadd_shopping_cart$45.00Inventory Cash Flow Management - 12-Month Forecast Excel Model
A way to plan out the cash needed to buy inventory in order to meet projected quantity demand by SKU.330Discussadd_shopping_cart$45.00Recycling Business - 10 Year Financial Excel Model
Specific revenue and expense logic designed for recycling used goods and selling them for a profit.2413add_shopping_cart$45.00Lending as a Service (LaaS): Running and Exit Financial Excel Model - 10 Year
This model is specific for a lending marketplace operator (Peer2Peer).283Discussadd_shopping_cart$95.00Customer Relation Manager - 6-Stage Tracker Model
Manage the tracking of your customer relationships from initial lead all the way to closed and possible churn.97Discussadd_shopping_cart$45.00Profit & Loss and Cash Flow Tracking (Weekly, Monthly, Annually) Template
Tracking profit and loss as well as cash position in real-time. Includes automated graph/visual updates.1694add_shopping_cart$45.00Equipment Rental - 10 Year Cash Flow Excel Model
The Equipment Rental business is a cash flow business. This bottom up forecast will help you craft scenarios.411Discussadd_shopping_cart$45.00Retail Industry: 5-Year Financial Excel Model
To forecast financial projections within any type of retail industry that sells various skus.5372add_shopping_cart$95.00Real Estate Investment Trust - 20 Year Financial Excel Model
A 20-Year model with easy plug-in assumptions to test various scenarios.216Discussadd_shopping_cart$35.00Enterprise Sales Pipeline Planning Spreadsheet - With Contract Renewal Probability
Set various enterprise contract details and define % to renewal in order to see various 5 year total contract values.87Discussadd_shopping_cart$45.00Gold Mining (or other metal) Excel Financial Model
Model up to 50 years of mining activity with up to 28 types of materials going at once.604Discussadd_shopping_cart$45.00Inventory Tracking Excel Template - Single Location - COGS Logic
An inventory management excel template designed for 1 location and focuses on deriving a cost of goods sold per sku.410Discussadd_shopping_cart$45.00Hair Salon - 10 Year Excel Financial Model
A financial planning tool designed specifically for the logic needed to project revenue and costs for a hair salon.250Discussadd_shopping_cart$45.00Document / Project Tracking Template
This is a basic template that shows the number of days events take to complete.99Discussadd_shopping_cartfreeFinancial Projections Excel Model Driven by Account Executive Performance/New Hires
Drive revenue projections based on how you think your account executives will perform over time. Extensive assumptions.176Discussadd_shopping_cart$45.00Kiosk - 3 Year Startup Financial Excel Model
Revenue and cost logic specific to running multiple kiosks.124Discussadd_shopping_cart$45.00Excel Calculator: Full Loan Pay Off or Invest it All
Compare the effects of paying off all your loans right away or using that money to invest with.97Discussadd_shopping_cart$20.00Food Truck Financial Excel Model (10 Year)
Build a bottom-up style business case for starting your own food truck.615Discussadd_shopping_cart$45.00Pawn Shop 5 Year Business Excel Financial Model
Enter assumptions directly related to the startup and operation of a pawn shop in order to see up to 5 year projections.337Discussadd_shopping_cart$45.00The Complete Venture Capital Bundle
This bundle of Venture Capital financial Excel models combines effective valuations, analysis and forecasting.446Discussadd_shopping_cart$190.0010-Year Joint Venture Excel Real Estate Model with Refi Logic
A detailed real estate model designed to be used to estimate future cash flows to the sponsor and investor(s).2694add_shopping_cart$70.00Freemium Model with CaC Payback - 5 Year Forecast
Forecast a 5-year financial plan based on logic specific to the freemium strategy.109Discussadd_shopping_cart$45.00Accounts Receivable and Payable Invoice Tracking Excel Model Template
Track who owes you money and how much as well as well as how much you owe and to who. Aging reports included.294Discussadd_shopping_cart$45.00World Class SaaS Model - Growth Driven by Headcount Ratios and Quota Attainment
This is a general 5-year SaaS financial model that runs on assumptions that determine ratios as well as deal quotas.45Discussadd_shopping_cart$95.00Dry Cleaning Business: Startup Pro-Forma Excel Model
Forecast revenues and expenses of a dry cleaning business with unique business logic specific to the industry.294Discussadd_shopping_cart$45.00Janitorial Service Business: Financial Model - 5 Year
A financial model for any kind of people-based service business. This is geared toward a janitorial cleaning service.110Discussadd_shopping_cart$45.00Zoo / Park / Aquarium - Construction and On-Going Operational Cash Flow Model
This model includes financial assumptions and logic specific to constructing and running a Zoo or similar operation.13Discussadd_shopping_cart$40.00Sales Gap Planner - Annual
A dashboard that shows your expected annual billings compared to your annual revenue goal.36Discussadd_shopping_cart$45.00Product-as-a-Service (PaaS) - Strategic Business Modeling Planner Excel Model
This is a startup financial model geared directly for a product-as-a-service business.99Discussadd_shopping_cart$70.00Retirement Planner Excel Model - Cash Flow Forecasting with Inflation Adjustment
Create an income generating schedule as well as budget your expenses for retirement.354Discussadd_shopping_cart$45.00ATM Machines - 10 Year Financial Excel Model Template
Scale out the purchase of ATM machines at various locations with deal level variable configuration.86Discussadd_shopping_cart$45.00Loan Pay Back Optimizer - Excel Model
Enter an extra payment allocation and see how this effects your total repayment across multiple loans.134Discussadd_shopping_cart$25.00Residential and Commercial Security Monitoring Service - Startup Financial Excel Model - 5 Year
Build a financial forecast with revenue and expense logic geared toward the security monitoring services industry.24Discussadd_shopping_cart$95.00Employee Scheduling Excel Template (30 minute blocks over 7 days)
This is an Excel tool for managers to better plan weekly schedules for their employees.56Discussadd_shopping_cart$45.00Startup 3-Statement Financial Model - General Use - Excel
This is a general use 3-statement financial model with monthly and annual views.65Discussadd_shopping_cart$45.00Multi-family Real Estate - Joint Venture Model - IRR Hurdles, Refinancing, and Exit Assumptions
Model up to a 10 year annual pro forma that caters to the specific assumptions related to multi-family real estate.21Discussadd_shopping_cart$45.00Simple In/Out Inventory Management Excel Template - 1 Location -
This excel model will help you track the quantity and value of your inventory.1,243Discussadd_shopping_cart$45.00Depreciation Compare Tool: Straight Line vs. Double-Declining Balance
Compare the two main types of depreciation as well as see a schedule that runs up to 30 years.16Discussadd_shopping_cart$40.00Preferred Return - Annual Waterfall - Includes Shortfall Repayment Option and More
A 10-year tool to help split cash flows between a sponsor and investor pool based on a defined 'true' preferred return.17Discussadd_shopping_cart$40.00The Complete Real Estate Bundle
This Real Estate bundle contains a combination of tools for calculating loans, investments and budgets for property.1685add_shopping_cart$150.00Budget to Buy a Home: Excel Tool
A self explanatory personal finance template to help anyone who is saving for a house.92Discussadd_shopping_cart$20.00Marketing ROI - Recurring and/or Irregular Revenues Excel Model Template
Track the actual ROI of your marketing spend over time.69Discussadd_shopping_cart$45.00Mobile Home Park Financial Excel Model Template - Up to 50 Years
Create a financial plan for the building or acquisition of a mobile home park. Get into affordable housing.194Discussadd_shopping_cart$95.00KPI Dashboard: Grading Your Metrics - Excel Template
This is a tool to help any organization track the health of their business across many operational departments.76Discussadd_shopping_cart$40.00Hiring Plan - 5-Year Ramp-Up Financial Model
A tool to estimate hiring needs per 3-month forward revenues.2663add_shopping_cart$45.00Religious Organization 5-Year Financial Planner
Specific logic related to forecasting the finances of a religious organization / church.30Discussadd_shopping_cart$45.00Inventory Manager for Re-Order Planning Excel Model
Help control and organize inventory re-ordering.49Discussadd_shopping_cart$40.00Cost per Unit (Manufacturing) Sensitivity Analysis Financial Excel Model
A simple, but helpful tool that helps a manufacturer plan various price points.239Discussadd_shopping_cart$45.00
