商务技能

Create a single PowerPoint slide summarizing recent funding activity in selected sectors or companies. Using S&P Global Capital IQ data, it highlights funding totals, company valuations, major investors, key trends, and links to individual deals.

中文简介正在准备中。当前显示英语简介。

• Weekly funding recaps for selected sectors
• Tracking funding rounds at watched companies
• Briefing colleagues on major deals and valuation changes

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

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

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

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

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

Reconcile general ledger and subledger extracts for the same entity, asset class, and date. Match transactions or positions, report differences in amounts, quantities, or posting dates, and summarize likely causes alongside the matching rate.

中文简介正在准备中。当前显示英语简介。

• Running daily ledger reconciliations
• Checking ledger differences at month-end
• Finding entries recorded in only one ledger

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

Investigate a mismatch between the general ledger and a supporting ledger by tracing both sides to their original entries. Compare transaction details and return a concise cause, responsible team, expected resolution date, and recommended action.

中文简介正在准备中。当前显示英语简介。

• Investigating a classified ledger reconciliation mismatch
• Comparing posting dates and exchange rates on both sides
• Identifying account mapping errors or duplicate transactions

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

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

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

Find stock investment candidates by combining financial filters with research into investment themes. Produce five to ten long or short ideas, each with a rationale and risks, plus a comparison table and priorities for further research.

中文简介正在准备中。当前显示英语简介。

• Finding stocks that meet value, growth, or quality criteria
• Identifying companies that benefit from an investment theme
• Screening short candidates for business or accounting concerns

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

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

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

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

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

Prepare concise Word profiles of public or private companies using S&P Capital IQ data. It adapts business and financial information for equity research, M&A, acquisition planning, or sales meetings, with checked calculations and clearly marked missing data.

中文简介正在准备中。当前显示英语简介。

• Preparing a company summary for equity research
• Profiling an M&A or acquisition target
• Preparing company background for a sales meeting

Build a competitive analysis presentation covering market context, company performance, strengths, and weaknesses. Compare competitors using consistent metrics, visualize their market positions, and summarize lasting advantages and structural risks for strategic or investment discussions.

中文简介正在准备中。当前显示英语简介。

• Mapping competitors and their market positions
• Comparing peer companies using shared metrics
• Preparing a strategic review presentation

Prepare an initial equity research report through five separate tasks covering company research, financial forecasts, valuation, charts, and report assembly. Outputs include research notes, an Excel financial model, chart files, and a detailed Word report.

中文简介正在准备中。当前显示英语简介。

• Researching a company’s business, competitors, and risks
• Building financial forecasts with three scenarios
• Estimating a price target using multiple valuation methods

Create a personalized investment proposal for a prospective client, covering goals, asset allocation, projected outcomes, fees, and transition steps. Outputs include a branded PowerPoint presentation, a PDF version, and a one-page summary for follow-up.

中文简介正在准备中。当前显示英语简介。

• Preparing an investment proposal for a prospective client
• Presenting a new investment strategy
• Explaining fees and projected outcomes

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

Prepare for investment client meetings by organizing account performance, comparing current and target asset allocations, and identifying discussion points. Create a one-page review summary, performance tables, allocation charts, an agenda, and recommended actions.

中文简介正在准备中。当前显示英语简介。

• Preparing materials for quarterly or annual client reviews
• Explaining portfolio returns and their main drivers
• Checking asset allocation against agreed targets