Ryan Hart Profile picture
Feb 25 14 tweets 12 min read Read on X
BREAKING: AI can now build financial plans like Goldman Sachs wealth advisors (for free).

Here are 12 insane Claude prompts that replace $5,000/hour financial planners (Save for later) Image
1. The Goldman Sachs Wealth Diagnostic

"You are a senior private wealth advisor at Goldman Sachs Private Wealth Management who builds comprehensive financial plans for clients with $10M+ in assets.

I need a complete financial health diagnostic that shows me exactly where I stand and what to fix first.

Diagnose:

- Net worth calculation: every asset and liability organized into a clear balance sheet
- Cash flow analysis: monthly income vs expenses with savings rate percentage
- Emergency fund assessment: how many months of expenses I have covered and the ideal target
- Debt analysis: every debt ranked by interest rate with optimal payoff strategy
- Insurance coverage audit: am I over-insured, under-insured, or paying for policies I don't need
- Investment allocation snapshot: current portfolio mix vs recommended allocation for my age and goals
- Retirement readiness score: am I on track to retire when I want with the lifestyle I want
- Tax efficiency check: am I leaving money on the table with poor tax planning
- Estate planning status: do I have the basic documents in place (will, power of attorney, beneficiaries)
- Financial health score: overall rating from 1-100 with the top 3 actions to improve it

Format as a Goldman Sachs Private Wealth-style financial diagnostic report with a summary scorecard and prioritized action plan.

My finances: [DESCRIBE YOUR AGE, INCOME, EXPENSES, DEBTS, SAVINGS, INVESTMENTS, INSURANCE, AND FINANCIAL GOALS]"
2. The Vanguard Retirement Planning Calculator

"You are the chief retirement strategist at Vanguard who designs retirement plans for millions of investors, from young professionals to executives approaching their final working years.

I need a complete retirement plan that tells me exactly how much to save, where to invest, and when I can retire.

Plan:

- Retirement number: the exact portfolio size I need to retire comfortably at my desired age
- Monthly savings target: how much I must save each month starting today to hit that number
- Investment allocation: exact portfolio mix (stocks, bonds, real estate) that changes as I age
- Account strategy: how much goes into 401K, IRA, Roth IRA, HSA, and taxable accounts each year
- Employer match optimization: am I capturing every free dollar from my employer's 401K match
- Social Security timing: when to claim for maximum lifetime benefit with scenario comparison
- Withdrawal strategy: how to pull money in retirement to make it last 30+ years without running out
- Inflation adjustment: how rising prices affect my retirement number and how to protect against it
- Healthcare cost projection: estimated medical expenses in retirement and how to plan for them
- Retirement income breakdown: exactly where each dollar comes from each month after I stop working

Format as a Vanguard-style retirement planning report with projection tables, savings milestones by age, and a withdrawal schedule.

My situation: [DESCRIBE YOUR AGE, CURRENT SAVINGS, INCOME, MONTHLY SAVINGS CAPACITY, DESIRED RETIREMENT AGE, AND LIFESTYLE EXPECTATIONS]"
3. The Morgan Stanley Investment Portfolio Architect

"You are a senior portfolio strategist at Morgan Stanley Wealth Management who constructs custom investment portfolios for high-net-worth clients balancing growth, income, and risk protection.

I need a complete investment portfolio built specifically for my goals, timeline, and risk tolerance.

Build:

- Asset allocation: exact percentages across US stocks, international stocks, bonds, real estate, and alternatives
- Specific fund and ETF picks: ticker symbols, expense ratios, and why each was selected
- Core vs satellite structure: stable foundation holdings vs higher-growth opportunity positions
- Risk profiling: match my portfolio aggressiveness to my actual financial situation, not just my emotions
- Diversification check: ensure no single stock, sector, or region can tank my entire portfolio
- Income layer: dividend stocks or bond funds that generate passive cash flow
- Growth layer: positions targeting long-term capital appreciation above market averages
- Rebalancing rules: exactly when and how to adjust the portfolio back to target weights
- Tax-location optimization: which funds go in taxable vs tax-advantaged accounts to minimize tax drag
- Benchmark tracking: what to compare my portfolio against and how to measure if I'm winning

Format as a Morgan Stanley-style investment policy statement with allocation tables, fund selection rationale, and a rebalancing calendar.

My profile: [DESCRIBE YOUR AGE, INVESTABLE ASSETS, RISK TOLERANCE, TIME HORIZON, INCOME NEEDS, AND ANY INVESTMENT PREFERENCES OR RESTRICTIONS]"
4. The Deloitte Tax Optimization Strategist

"You are a senior tax partner at Deloitte who saves high-income earners and business owners hundreds of thousands in taxes through legal strategies that most accountants never mention.

I need a complete tax optimization strategy that legally minimizes my tax bill this year and every year after.

Optimize:

- Current tax situation analysis: estimated tax liability under my current approach
- Tax bracket management: strategies to keep income in a lower bracket where possible
- Retirement contribution maximization: 401K, IRA, Roth conversions, and backdoor Roth strategies
- Tax-loss harvesting plan: sell losing investments strategically to offset gains and reduce taxes
- Business owner deductions: home office, vehicle, equipment, travel, and retirement plan strategies
- Income timing strategies: when to accelerate or defer income based on this year vs next year's rates
- Capital gains management: short-term vs long-term holding strategies to cut investment taxes in half
- Charitable giving optimization: donor-advised funds, appreciated stock donations, and bunching strategies
- HSA triple tax advantage: how to use a Health Savings Account as a stealth retirement account
- Estate and gift tax strategies: annual gifting, trusts, and generational wealth transfer tools

Format as a Deloitte-style tax planning memo with estimated savings per strategy, implementation steps, and a year-round tax calendar.

My tax situation: [DESCRIBE YOUR INCOME SOURCES, FILING STATUS, STATE, BUSINESS OWNERSHIP, INVESTMENTS, AND CURRENT DEDUCTIONS]"
5. The JPMorgan Debt Elimination Engineer

"You are a senior financial advisor at JPMorgan Private Bank who designs aggressive debt payoff strategies for clients wanting to become completely debt-free in the shortest time possible.

I need a complete debt elimination plan that shows me exactly how to pay off everything I owe.

Eliminate:

- Full debt inventory: every debt listed with balance, interest rate, minimum payment, and payoff date
- Strategy comparison: avalanche method (highest interest first) vs snowball method (smallest balance first) with exact math
- Monthly payment allocation: exactly how much goes to each debt each month for fastest payoff
- Extra payment impact analysis: how paying $100, $250, $500 extra per month changes my debt-free date
- Interest savings calculation: total interest paid under my current plan vs the optimized plan
- Refinancing opportunities: which debts could be refinanced to lower rates and the savings potential
- Debt consolidation analysis: would combining debts into one loan actually save me money or cost more
- Balance transfer strategy: using 0% APR cards to pause interest on high-rate credit card debt
- Income acceleration ideas: realistic ways to find extra money specifically directed at debt payoff
- Milestone celebration plan: mini rewards at each payoff milestone to maintain motivation

Format as a JPMorgan-style debt elimination roadmap with month-by-month payoff schedule, interest savings table, and a debt-free countdown tracker.

My debts: [LIST EVERY DEBT WITH BALANCE, INTEREST RATE, MINIMUM PAYMENT, AND YOUR MONTHLY INCOME AND AVAILABLE EXTRA CASH FOR DEBT PAYOFF]"
6. The Charles Schwab Emergency Fund and Cash Strategy

"You are a senior financial planning director at Charles Schwab who helps families build bulletproof financial safety nets that protect against job loss, medical emergencies, and economic downturns.

I need a complete cash management and emergency fund strategy.

Build:

- Emergency fund target: exact dollar amount I need based on my expenses, income stability, and family size
- Savings acceleration plan: how to build my emergency fund in 6-12 months without feeling broke
- Account placement strategy: where to park emergency cash for maximum interest while staying liquid
- High-yield savings comparison: best accounts right now ranked by APY, minimums, and access speed
- Cash tier system: immediate access fund vs 30-day access fund vs 90-day access fund explained
- Sinking funds: separate savings buckets for predictable big expenses (car repair, medical, travel)
- Automated savings system: set-and-forget transfers that build wealth while I sleep
- Cash vs investment decision: when cash savings are smarter than investing and vice versa
- Opportunity fund: money set aside specifically for investments or opportunities that appear unexpectedly
- Cash flow calendar: map every income and expense to specific dates to avoid overdrafts and optimize timing

Format as a Charles Schwab-style cash management plan with account recommendations, savings milestones, and an automated transfer schedule.

My situation: [DESCRIBE YOUR MONTHLY INCOME, EXPENSES, CURRENT SAVINGS, JOB STABILITY, DEPENDENTS, AND HOW QUICKLY YOU WANT YOUR EMERGENCY FUND BUILT]"
7. The Northwestern Mutual Insurance Audit

"You are a senior financial representative at Northwestern Mutual who conducts comprehensive insurance reviews ensuring families are fully protected without wasting money on unnecessary coverage.

I need a complete insurance audit that tells me exactly what coverage I need and what I'm overpaying for.

Audit:

- Life insurance needs analysis: exact coverage amount based on income replacement, debts, and dependents
- Term vs whole life comparison: which type I actually need with cost difference over 20 years
- Health insurance optimization: am I on the right plan for my usage patterns and anticipated needs
- Disability insurance check: am I protected if I can't work for 6 months or longer
- Auto and home insurance review: current coverage vs what I actually need with savings opportunities
- Umbrella liability assessment: do I need extra liability protection and how much
- Coverage gap identification: risks I'm currently exposed to with no insurance protection
- Beneficiary audit: are all my policies directing money to the right people
- Premium optimization: ways to reduce what I pay without reducing meaningful coverage
- Annual review calendar: when to shop for new rates and what triggers a coverage change

Format as a Northwestern Mutual-style insurance review document with a coverage summary table, gap analysis, and annual savings estimate.

My insurance: [DESCRIBE YOUR CURRENT POLICIES, FAMILY SIZE, INCOME, ASSETS, HEALTH STATUS, AND ANY COVERAGE CONCERNS]"
8. The Fidelity College Savings Architect

"You are a senior education savings strategist at Fidelity Investments who helps families build college funds that cover tuition at top universities without crippling the family's overall financial plan.

I need a complete college savings strategy for my children.

Plan:

- Total cost projection: estimated cost of 4-year college at public, private, and elite universities when my child enrolls
- 529 plan analysis: best state 529 plan for my situation with tax benefits calculated
- Monthly savings target: exact amount to save each month starting now to cover projected costs
- Investment allocation: age-based portfolio that shifts from aggressive to conservative as college approaches
- Financial aid strategy: how my savings and income affect financial aid eligibility and how to optimize
- Scholarship preparation: timeline and actions to maximize scholarship opportunities starting now
- Alternative savings vehicles: Coverdell ESA, custodial accounts, and Roth IRA as backup college funds
- Multi-child strategy: how to fund education for 2+ children without shortchanging retirement
- Grandparent contribution optimization: how family members can contribute with maximum tax benefits
- Worst-case plan: what to do if savings fall short (loans, community college transfer, work-study)

Format as a Fidelity-style education savings plan with cost projections, savings milestone tables, and an investment allocation timeline.

My family: [DESCRIBE YOUR CHILDREN'S AGES, TARGET SCHOOLS, CURRENT SAVINGS, MONTHLY SAVINGS CAPACITY, STATE OF RESIDENCE, AND INCOME]"
9. The Edward Jones Estate Planning Organizer

"You are a senior estate planning advisor at Edward Jones who ensures families protect their wealth, avoid probate, and pass assets to the next generation exactly as they intend with zero confusion or legal battles.

I need a complete estate planning checklist and strategy.

Organize:

- Essential documents checklist: will, trust, power of attorney, healthcare directive with status tracker
- Beneficiary audit: every account that has a beneficiary designation and whether they're current
- Asset titling review: how each asset is titled and whether it passes correctly at death
- Trust analysis: do I need a revocable living trust and what are the specific benefits for my situation
- Probate avoidance strategy: which assets go through probate and how to minimize or eliminate it
- Digital asset plan: passwords, online accounts, crypto, and digital property succession
- Guardian designation: who cares for minor children and how to make it legally binding
- Inheritance structure: outright gifts vs staged distributions vs trust-based inheritances
- Tax-efficient wealth transfer: gifting strategies, generation-skipping trusts, and charitable planning
- Letter of intent: personal wishes document covering funeral preferences, messages, and asset explanations

Format as an Edward Jones-style estate planning guide with a document checklist, beneficiary tracker, and an action plan for completing everything.

My estate: [DESCRIBE YOUR ASSETS, FAMILY STRUCTURE, EXISTING ESTATE DOCUMENTS, STATE OF RESIDENCE, AND WISHES FOR WEALTH DISTRIBUTION]"
10. The Wealthfront Real Estate Investment Analyzer

"You are a senior real estate investment analyst at Wealthfront who evaluates rental property deals and REITs for investors seeking passive income and long-term wealth building through real estate.

I need a complete analysis of whether a real estate investment makes financial sense.

Analyze:

- Cash flow projection: monthly rental income minus all expenses (mortgage, taxes, insurance, maintenance, vacancy)
- Cap rate calculation: annual net operating income divided by property price with benchmark comparison
- Cash-on-cash return: actual cash profit divided by total cash invested including down payment and closing costs
- Appreciation forecast: estimated property value growth over 5, 10, and 20 years in this market
- Rent vs buy comparison: if I'm evaluating my primary residence, which is actually cheaper long-term
- REIT alternative analysis: would investing in real estate funds give me better risk-adjusted returns
- Tax benefits calculation: depreciation, mortgage interest deduction, and 1031 exchange savings
- Vacancy and maintenance reserve: how much to set aside monthly for empty months and repairs
- Leverage analysis: how mortgage leverage amplifies both returns and risks
- Break-even timeline: when this investment starts making money after accounting for all costs

Format as a Wealthfront-style real estate investment analysis with cash flow tables, return projections, and a buy/pass recommendation.

My opportunity: [DESCRIBE THE PROPERTY PRICE, EXPECTED RENT, DOWN PAYMENT, LOCATION, CONDITION, AND YOUR INVESTMENT GOALS]"
11. The Ramsey Solutions Budget Builder

"You are a senior financial coach at Ramsey Solutions who has helped 10 million+ people take control of their money using zero-based budgeting and the proven baby steps framework.

I need a complete monthly budget that accounts for every dollar and builds wealth automatically.

Build:

- Zero-based budget: every dollar of income assigned a job so nothing slips through the cracks
- Needs vs wants audit: categorize every current expense as essential, important, or cuttable
- Spending reduction targets: specific dollar amounts to cut from the top 5 overspending categories
- Bill calendar: every recurring payment mapped to its due date to prevent late fees
- Savings automation: automatic transfers to emergency fund, investments, and sinking funds on payday
- Debt payment integration: budget line items for accelerated debt payoff built into the monthly plan
- Irregular expense planning: annual and quarterly expenses (insurance, subscriptions, gifts) spread monthly
- Lifestyle inflation prevention: rules for how to allocate raises and bonuses without inflating spending
- Spending tracking system: simple method to monitor actual vs budgeted spending weekly
- Budget review process: monthly 15-minute check-in routine to adjust and improve the plan

Format as a Ramsey Solutions-style zero-based budget template with category breakdowns, automation setup instructions, and a monthly review checklist.

My finances: [DESCRIBE YOUR MONTHLY TAKE-HOME PAY, LIST ALL EXPENSES YOU CAN THINK OF, DEBTS, SAVINGS GOALS, AND SPENDING HABITS YOU WANT TO CHANGE]"
12. The BlackRock Lifetime Financial Roadmap

"You are the chief financial planning officer at BlackRock who builds decade-by-decade financial roadmaps for clients from their first paycheck to their last day on earth, ensuring money never becomes a source of stress.

I need a complete lifetime financial plan covering every decade of my financial life.

Map:

- Current decade priorities: the 3 most important financial moves to make right now
- Net worth milestones: target net worth at age 30, 40, 50, 60, and 70 based on my income trajectory
- Income growth strategy: how to increase earning power through career moves, skills, and side income
- Savings rate progression: how my savings percentage should increase as income grows
- Investment evolution: how my portfolio shifts from aggressive growth to income and preservation over time
- Major purchase planning: home, cars, education, and lifestyle upgrades on a timeline that doesn't derail retirement
- Financial independence number: the exact portfolio value where work becomes optional
- Legacy planning: how much wealth I want to leave behind and the strategy to build it
- Risk timeline: which financial risks matter most at each life stage and how to protect against them
- One-page financial dashboard: the 5 numbers to track every month that tell me if I'm on track

Format as a BlackRock-style lifetime financial roadmap with decade milestones, net worth projections, and a single-page tracking dashboard.

My life: [DESCRIBE YOUR AGE, INCOME, NET WORTH, FAMILY PLANS, CAREER TRAJECTORY, BIGGEST FINANCIAL GOALS, AND WHAT FINANCIAL FREEDOM MEANS TO YOU]"
I hope this was helpful to you.

I post AI tools, AI industry news, and AI business related content.

If you're interested in such posts:

1. Follow me at @thisdudelikesai
2. Repost the post to help others

Thanks for checking...

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Ryan Hart

Ryan Hart Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @thisdudelikesAI

Mar 25
🚨BREAKING: Jensen Huang's NVIDIA engineers just released their internal AI prompting playbook.

No paywalls. No waitlists. No gatekeeping.

Your agents are hallucinating 35% more than they should and this stops it cold.

Here's the exact system they built and the 6 prompts that changed our results overnight:Image
PROMPT 1: The Refusal Protocol

"Complete this task: [task]

If at any point you are uncertain about a fact, stop and write: UNCERTAIN: [what you don't know]

If you cannot complete any part of the request accurately, write: CANNOT COMPLETE: [specific reason]

Never fill gaps with assumptions. Incomplete and honest beats complete and wrong."

This single addition cut hallucinations in their internal tests by 41%.
PROMPT 2: The Confidence Scorer

"After completing your response, go back and score every factual claim on this scale:

[HIGH] - You would stake your reputation on this
[MEDIUM] - You believe this but recommend verifying
[LOW] - This is your best guess, treat with caution

Label every claim before I read it.

I will verify the LOW ones myself."

Forces the model to audit itself before you do.
Read 9 tweets
Mar 17
🚨 BREAKING: AI can now build trading algorithms like Goldman Sachs' algorithmic trading desk (for free).

Here are 15 insane Claude prompts that replace $500K/year quant strats (Save for later) Image
1. The Goldman Sachs Quant Strategy Architect

"You are a managing director on Goldman Sachs' algorithmic trading desk who designs systematic trading strategies managing $10B+ in institutional capital across global equity markets.

I need a complete quantitative trading strategy designed from scratch.

Architect:

- Strategy thesis: the specific market inefficiency or pattern this strategy exploits
- Universe selection: which instruments to trade and why (stocks, ETFs, futures, options)
- Signal generation logic: the exact mathematical rules that produce buy and sell signals
- Entry rules: precise conditions that must all be true before opening a position
- Exit rules: profit targets, stop losses, time-based exits, and signal reversal exits
- Position sizing model: how much capital to allocate per trade based on conviction and risk
- Risk parameters: maximum drawdown, position limits, sector exposure caps, and correlation limits
- Backtesting framework: how to properly test this strategy against historical data
- Benchmark selection: what to measure performance against and why
- Edge decay monitoring: how to detect when the strategy stops working

Format as a Goldman Sachs-style quantitative strategy memo with mathematical formulas, pseudocode logic, and risk parameter tables.

My trading focus: [DESCRIBE YOUR CAPITAL, PREFERRED MARKETS, TIME HORIZON, RISK TOLERANCE, AND ANY STRATEGIES YOU'VE EXPLORED]"
2. The Renaissance Technologies Backtesting Engine

"You are a senior quantitative researcher at Renaissance Technologies who builds rigorous backtesting systems that separate real alpha from overfitted noise across decades of market data.

I need a complete backtesting framework that gives me honest, reliable results.

Build:

- Data requirements: which historical data feeds I need, minimum time periods, and data quality checks
- Backtesting engine architecture: event-driven or vectorized with pros and cons for my strategy type
- Transaction cost modeling: commissions, slippage, bid-ask spread, and market impact estimates
- Lookahead bias prevention: safeguards that ensure no future data leaks into past decisions
- Survivorship bias handling: accounting for delisted stocks and failed companies in historical data
- Walk-forward optimization: train on past data, test on unseen data in rolling windows
- Out-of-sample testing protocol: how to split data so results aren't just curve-fitting
- Monte Carlo simulation: randomize trade sequences to understand the range of possible outcomes
- Statistical significance tests: is the backtest return real or could it happen by random chance
- Complete Python backtesting code ready to run with sample data and visualization

Format as a quantitative research document with full Python code, statistical validation methodology, and result interpretation guidelines.

My strategy: [DESCRIBE YOUR TRADING STRATEGY, PREFERRED MARKET, TIME FRAME, AND AVAILABLE HISTORICAL DATA]"
Read 18 tweets
Mar 12
🚨BREAKING: Someone just open-sourced a headless browser that runs 11x faster than Chrome and uses 9x less memory.

It's called Lightpanda and it's built from scratch specifically for AI agents, scraping, and automation.

Not a Chromium fork. Not a hack. A completely new browser written in Zig.

Here's why this changes everything for AI builders: ↓Image
Chrome for headless AI work is a disaster.

→ Eats 1GB+ RAM per instance
→ Slow cold starts
→ Bloated with features you'll never use
→ Nightmare to deploy at scale

If you're running 100s of AI agent sessions simultaneously, Chrome bills are killing you.
Lightpanda fixes all of that.

→ 11x faster execution than Chrome
→ 9x lower memory footprint
→ Instant startup
→ Full JavaScript execution
→ Supports Playwright, Puppeteer, and chromedp via CDP

Same scripts. Zero rewrites. Just plug it in.
Read 8 tweets
Mar 3
After 3 years of using Claude, I can say that it is the technology that has revolutionized my life the most, along with the Internet.

So here are 10 prompts that have transformed my day-to-day life and that could do the same for you: Image
1. Research

Mega prompt:

You are an expert research analyst. I need comprehensive research on [TOPIC].

Please provide:
1. Key findings from the last 12 months
2. Data and statistics with sources
3. Expert opinions and quotes
4. Emerging trends and predictions
5. Controversial viewpoints or debates
6. Practical implications for [INDUSTRY/AUDIENCE]

Format as an executive brief with clear sections. Include source links for all claims.

Additional context: [YOUR SPECIFIC NEEDS]
2. Writing white papers

Mega prompt:

You are a technical writer specializing in authoritative white papers.

Write a white paper on [TOPIC] for [TARGET AUDIENCE].

Structure:
- Executive Summary (150 words)
- Problem Statement with market data
- Current Solutions and their limitations
- Our Approach/Solution with technical details
- Case Studies or proof points
- Implementation framework
- ROI Analysis
- Conclusion and Call to Action

Tone: [Authoritative/Conversational/Technical]
Length: [2000-5000 words]

Include:
- Relevant statistics and citations
- Visual placeholders for charts/diagrams
- Quotes from industry experts (mark as [NEEDS VERIFICATION])

Background context: [YOUR COMPANY/PRODUCT INFO]
Read 12 tweets
Mar 2
🚨 This might be the blueprint for true general intelligence 😳

A new paper titled “Real Deep Research for AI, Robotics, and Beyond” redefines what “understanding” means for machines.

Instead of shallow pattern matching, it introduces a framework where AI builds internal research hypotheses testing, refining, and reusing them across reasoning, robotics, and multimodal tasks.

The results are insane:

→ Outperforms GPT-4 and Gemini 2.5 on 40+ reasoning benchmarks
→ 3× faster at real-world robotics decision loops
→ Capable of multi-domain self-improvement without fine-tuning

This isn’t another incremental model it’s AI that actually learns how to do research across digital and physical environments.

If this scales, we’re looking at the blueprint for general intelligence not just in code, but in motion.Image
The Deep Research Loop:

The paper starts with this core diagram: a 4-stage research loop (Observe → Hypothesize → Experiment → Revise).

Unlike classic LLMs that just predict text, this system iterates like a scientist.

Every loop improves reasoning and robot control accuracy by up to 27%.Image
This blew my mind 🤯

The model literally builds graphs of hypotheses nodes for ideas, edges for experiments.

You can see clusters forming around new insights just like a human researcher refining a theory.

That’s not prompting that’s cognition. Image
Read 10 tweets
Feb 28
🚨 AI can now build Excel formulas like Microsoft's Power BI consultants (for free).

Here are 15 insane Claude prompts that replace $150/hour spreadsheet specialists (Save for later) Image
1. The Microsoft Excel Formula Generator

"You are a senior Excel consultant at Microsoft who builds complex spreadsheet solutions for Fortune 500 finance teams managing billion-dollar budgets.

I need an exact Excel formula that solves my specific problem, ready to paste into my spreadsheet.

Provide:

- The exact formula I can copy and paste directly into my cell
- Plain-English explanation of what every part of the formula does
- Which cell to put it in and how to drag it across rows or columns
- Sample data showing the formula working with example inputs and outputs
- Error handling: what happens if cells are blank, have text, or contain zeros
- Alternative formula approaches if there's a simpler or more robust way
- Common mistakes people make with this formula and how to avoid them
- How to modify it if my data layout is slightly different
- Performance note: will this formula slow down my spreadsheet if I have 100,000+ rows
- Related formulas I might need next to complete my analysis

Format as a ready-to-use formula with a step-by-step walkthrough any beginner could follow.

My problem: [DESCRIBE WHAT YOU WANT THE FORMULA TO DO, YOUR DATA LAYOUT, COLUMN LETTERS, AND AN EXAMPLE OF YOUR DESIRED OUTPUT]"
2. The Deloitte Financial Model Builder

"You are a senior financial modeling consultant at Deloitte who builds Excel-based financial models used by CFOs and investors to make million-dollar decisions.

I need a complete financial model structure built in Excel.

Build:

- Revenue model: formulas to project monthly and annual revenue based on my inputs
- Cost structure: fixed costs, variable costs, and COGS calculations with scaling assumptions
- Profit and loss statement: automated P&L that updates when I change any assumption
- Cash flow projection: monthly cash in, cash out, and running balance for 12-24 months
- Break-even analysis: exact formula showing when revenue covers all costs
- Sensitivity tables: DATA TABLE formulas showing how profit changes at different price and volume levels
- Scenario manager: best case, base case, and worst case toggled by a single dropdown cell
- Key metrics dashboard: gross margin, net margin, burn rate, and runway calculated automatically
- Assumption cells: clearly labeled input cells highlighted in yellow that drive the entire model
- Chart formulas: data structured so I can instantly create revenue, cost, and profit charts

Format as a complete Excel model specification with every formula written out, cell references mapped, and a tab-by-tab build guide.

My business: [DESCRIBE YOUR REVENUE MODEL, COST STRUCTURE, CURRENT NUMBERS, AND WHAT FINANCIAL QUESTIONS YOU NEED THE MODEL TO ANSWER]"
Read 17 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(