비즈니스 스킬

Complete an existing financial model template by entering historical data and forecast assumptions, then linking the income statement, balance sheet, and cash flow statement with formulas. Check statement balances, cash consistency, and scenario behavior as each section is completed.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Complete a partially filled financial model
• Link forecasts across three financial statements
• Check balance sheet and cash flow consistency

Prepare for one company's upcoming earnings announcement with a compact HTML report. It combines the latest earnings call, competitor comparisons, valuation measures, and recent news, with links to supporting sources and calculation details.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Preparing a company earnings preview
• Comparing valuation with listed competitors
• Reviewing management guidance and key risks

Track upcoming events that may affect investments, including earnings, product launches, regulatory decisions, and economic releases. Create a sortable Excel calendar and weekly preview covering event importance, expectations, and potential effects on existing positions.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Tracking earnings and announcements across selected companies
• Reviewing important investment events for the coming week
• Assessing upcoming events affecting portfolio holdings

Build an Excel comparison of public companies using financial performance, valuation ratios, and statistical benchmarks. The spreadsheet includes formulas, source notes, medians, and quartiles to show how each company compares with its peers.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Comparing public company valuations for M&A
• Benchmarking performance against industry peers
• Identifying unusually high or low valuation ratios

Maintain the reasoning behind portfolio holdings and watchlist companies. Record new developments, assess whether they support or weaken each argument, and produce an updated scorecard with confidence levels, upcoming events, and possible position changes.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Recording the rationale for a new investment
• Updating an investment thesis after earnings or news
• Reviewing arguments that support or challenge a holding

Evaluates currency trades that aim to earn interest rate differences. It combines spot and forward prices, expected volatility, and historical trends to compare potential returns against risk across holding periods and present trade recommendations.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Comparing currency pairs for interest rate carry
• Choosing a trade tenor using forward curves
• Comparing carry returns against expected volatility

Review a bond portfolio by combining prices, yields, sensitivity to interest rates, holdings breakdowns, and projected payments. Produce portfolio summaries and scenario tables that show how rate changes could affect gains and losses.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Reviewing a bond portfolio's composition
• Assessing sensitivity to interest rate changes
• Checking quarterly coupon and principal payments

Build dashboards that combine economic indicators, bond yields, market inflation expectations, and swap rates. Summarize the economic cycle, policy outlook, and financial conditions, including real interest rates, which account for expected inflation.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Monitoring a country's economic conditions
• Analyzing the shape of a government yield curve
• Separating nominal rates into inflation expectations and real rates

Estimate private equity deal returns across purchase prices, borrowing levels, growth assumptions, exit prices, and holding periods. Produce Excel sensitivity tables showing annualized returns and investment multiples, plus scenario comparisons and a one-page investment committee summary.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Estimate returns for a potential acquisition
• Compare purchase and exit valuation assumptions
• Stress-test growth and borrowing assumptions

Analyze price differences between bond futures and cash bonds, identify the cheapest bond to deliver, and compare implied financing rates with market rates. Present valuation tables and historical context to assess potential basis trades.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Comparing bond futures with cash bond prices
• Identifying the cheapest bond to deliver
• Comparing implied financing rates with market rates

Assess stock, index, or currency options by comparing expected price variability implied by option prices with actual historical variability. Summarize pricing, risk sensitivities, and patterns across expiry dates and exercise prices to inform strategy choices.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Comparing implied and historical volatility
• Examining volatility across expiries and exercise prices
• Reviewing option prices and risk sensitivities

Assess whether bonds are expensive, cheap, or fairly priced by comparing yields with government rates and credit risk benchmarks. Combine spread breakdowns, historical context, and interest rate scenarios into tables and a recommendation.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Comparing the relative value of candidate bonds
• Separating credit risk from other yield differences
• Estimating gains and losses under interest rate shifts

Draft investment committee memos for private equity deals, investments in privately held companies. Combine due diligence findings, financial analysis, deal terms, return scenarios, and risks into a structured document with a clear recommendation.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Preparing approval materials for an investment committee
• Combining due diligence findings into a deal memo
• Comparing base, upside, and downside return scenarios

Review portfolio company financial reports in Excel, PDF, or CSV, compare key measures with budgets and prior periods, and summarize performance trends, warning signs, and compliance with financial conditions in loan agreements.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Reviewing monthly performance against budget
• Preparing financial summaries for board meetings
• Checking financial conditions in loan agreements

Create stock research notes combining analyst forecasts, reported financials, price history, and economic conditions. Compare market expectations with business performance, present valuation measures, and summarize an investment case with positive scenarios, risks, and potential catalysts.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Preparing an initial research note on a stock
• Comparing analyst forecasts with reported results
• Reviewing financial trends and stock valuation

Analyze interest rate swaps, contracts that exchange interest payments, across maturities. Compare swap rates with government yields and inflation expectations, then present curve measures and trade proposals with balanced interest rate exposure, holding returns, and risk limits.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Comparing swap rates and government yields across maturities
• Estimating real rates using inflation expectations
• Assessing trades based on changes in the curve’s slope

Check investor statements against a fund's NAV pack, the records of its net asset value. Recalculate each investor's capital balance, compare statement lines, and report discrepancies with their causes before statements are distributed.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Checking investor statements before distribution
• Tracing differences in allocated profit or loss
• Checking capital balances across reporting periods

Prepare a period-end accrual schedule for expenses incurred but not yet fully recorded. Apply company policy, subtract amounts already booked, cite supporting records, and draft journal entries for controller approval, including reversal notes where required.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Preparing an accrual schedule for month-end close
• Calculating audit fee, bonus, or utilities accruals
• Drafting journal entries with supporting references

Build a balance-sheet account schedule showing how the opening balance changes into the closing balance. Link each movement to general ledger records or supporting documents, check the arithmetic, and report any unexplained difference for close or audit work.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Preparing balance movement schedules for month-end close
• Linking account movements to evidence for an audit
• Checking opening-to-closing balance reconciliation

Turn current, prior-period, and budget figures into a financial variance commentary table. It identifies lines needing explanation, traces changes to underlying business activity, and adds a short narrative covering the period's largest movements.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Preparing month-end close commentary
• Explaining actual results against budget
• Reviewing major balance-sheet movements

Create quarterly earnings reports for companies already being followed. Compare results with market expectations, explain differences, revise forecasts, and assess the investment case in a Word document with charts, summary tables, and linked sources.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Writing a report after a quarterly earnings release
• Explaining results above or below market expectations
• Revising forecasts after new company guidance

Complete Excel templates for leveraged buyouts, acquisitions financed partly with debt. Add linked formulas for funding, operations, debt repayment, and investment returns, then check calculations and formatting while reviewing each major section with the user.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Completing an existing Excel buyout model template
• Checking funding totals and debt repayment priorities
• Calculating investment returns for committee materials

Extract identity, ownership, control, and source-of-funds details from investor or client onboarding documents into a structured JSON record. Inventory the submitted documents and flag obvious missing or expired items before passing the information to KYC screening rules.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Organize investor onboarding documents
• Extract beneficial owners and controlling persons
• Check for missing or expired documents

Builds an Excel model to estimate a company’s equity value from future cash flows. It calculates financing costs, compares three business scenarios, and shows how changes in growth, margins, and other assumptions affect valuation.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Estimating a company’s value from future cash flows
• Comparing bear, base, and bull scenarios
• Testing how growth and financing costs affect valuation