time pass
zz
Prompt
Act as an undergraduate finance student writing a clean, straightforward academic report for a coursework assignment. ### REQUIRED OUTPUT FORMAT (Downloadable PDF via Browser) Format your ENTIRE response inside a single HTML code block (`<!DOCTYPE html>...</html>`). Include a `<style>` block at the top with clean styling for print/PDF export: - @page { size: A4; margin: 20mm; } - Clean system fonts (Arial/Calibri), 11pt body text, 1.4 line height - Explicit page-break rules (`page-break-inside: avoid;` for tables and charts) so it exports to PDF smoothly without broken text. - Standard academic color scheme (navy headers, clean borders for tables). --- ### TONAL & STYLE INSTRUCTIONS (To Avoid "AI Sounding" Text): 1. Write in clear, natural, and accessible English. Avoid hyper-academic jargon or AI clichés (do NOT use words like "tapestry," "delve," "testament," "paramount," "beacon," "pivotal," "multifaceted," or "underscore"). 2. Write direct, simple sentences. Explain financial concepts naturally, as if presenting in class. 3. Keep the layout simple, logical, and easy to read. --- ### ASSIGNMENT DETAILS - Main Subject / Primary Asset: SpaceX (evaluated via private market valuation & aerospace sector tracking data) - Comparison Assets: S&P 500 (^GSPC), Nasdaq Composite (^IXIC), S&P Aerospace & Defense Select Industry Index (SPSIAD), and MSCI World Index (URTH) - Timeframe: 5 September 2025 to 5 September 2026 - Return Calculation Formula: Daily Simple Return (%) = [(Price_today - Price_yesterday) / Price_yesterday] * 100 - Tool Used: Microsoft Excel --- ### REPORT SECTIONS TO INCLUDE IN THE HTML CODE: 1. Title & Header Include Assignment Title ("Descriptive Statistics of Stock Market Returns"), Student Name, Date, and Subject. 2. Introduction Briefly explain why tracking stock market returns and daily volatility matters, and why comparing SpaceX against major indices (S&P 500, Nasdaq, MSCI World, Defense sector) gives a realistic view of market risk. 3. Details of Selected Assets & Indices List all 5 selected assets with a 2-sentence breakdown of what each represents. 4. Data Source and Study Period State the study period (5 September 2025 to 5 September 2026) and primary data sources (Yahoo Finance / private valuation trackers). 5. Method of Calculating Returns Show the formula: Return (%) = [(P_t - P_{t-1}) / P_{t-1}] * 100. Explain in plain text why daily returns are used instead of raw index prices. 6. Descriptive Statistics Table Render a formatted HTML table containing realistic statistical values over ~252 trading days for all 5 assets across these 11 metrics: (Mean, Median, Mode, Minimum, Maximum, Range, Variance, Standard Deviation, Coefficient of Variation, Skewness, Kurtosis). 7. Chart Setup & Description Provide a brief step-by-step guide on creating the multi-line chart in Excel, followed by a paragraph describing what the visual return trends show. 8. Comparative Analysis Answer these 8 questions directly based on the table data: 1. Highest average return index? 2. Lowest average return index? 3. Highest volatility (Standard Deviation)? 4. Lowest volatility? 5. Most consistent returns? 6. Skewness interpretation? 7. Kurtosis (fat tails/extreme events) interpretation? 8. Most attractive risk-return profile? 9. Conclusion & Excel Formulas Summarize key takeaways in 2 short paragraphs and list 3 key Excel formulas used (=AVERAGE(), =STDEV.S(), =SKEW()).
A system prompt was added to support web rendering
