Overview of My Work
Welcome to my portfolio of academic and professional projects. Here, you’ll find a curated selection of assignments and analyses that showcase my skills in data visualization, financial modeling, and business communication. Each project represents my commitment to solving real-world challenges through thoughtful analysis, clear communication, and attention to detail.
Feel free to explore the individual projects below to learn more about my work and the impact it can create.
Commercial Real Estate Investment Underwriting Case Study
Developed a lender-oriented underwriting analysis to evaluate a commercial real estate investment under a structured set of operating, financing, and exit assumptions. The model translated property-level cash flow into value, capital structure, debt obligations, and disposition proceeds over a 10-year hold period to assess overall deal viability.
• Built a property-level pro forma using prior-year actuals, the rent roll, and market assumptions to
derive implied value based on stabilized operating income
• Forecasted 10-year cash flows and terminal sale proceeds to analyze hold-period performance
under the assumed financing and exit structure
• Evaluated DSCR and levered IRR return to assess debt capacity, equity
performance, and overall deal viability
• Average 10-year DSCR of 1.70 and a levered IRR of 17.54%
San Francisco Office Market Analysis (2026)
Conducted a market analysis of the San Francisco office sector, examining key economic, demographic, and real estate fundamentals.
Evaluated population trends, income levels, employment growth, and demographic characteristics to understand demand drivers for office space.
Analyzed office market fundamentals, including vacancy rates, rental pricing, leasing activity, and tenant demand trends.
Reviewed supply conditions and development activity, including the performance differences between Class A and older office properties.
Assessed the overall market outlook and potential investment opportunities, including the repositioning of underperforming office assets.
Fixed Income Analysis: Corporate Bond Valuation & Interest Rate Sensitivity
This project applies fixed income valuation techniques to analyze a corporate bond using real market data, including pricing, duration analysis, credit spread estimation, and interest rate sensitivity modeling.
• Constructed a fixed income valuation model to estimate corporate bond price
using present value analysis of bond cash flows
• Calculated Macaulay Duration and Modified Duration to measure
interest rate risk and price sensitivity
• Derived the credit spread relative to a comparable U.S. Treasury benchmark
to isolate corporate credit risk
• Performed yield sensitivity analysis to evaluate bond price responses
across multiple interest rate scenarios
Tableau Project: Downtown Office Supply
Project Overview:
This Tableau dashboard analyzes over 5,000 sales transactions to identify key trends and improve business performance.
Reduced reporting time by 40% with automated dashboards.
Provided insights on monthly sales growth, top products, and customer demographics.
Increased data accessibility by 25% with interactive visualizations.
Accounting Projects
Financial Analysis & 3-Statement Model
These accounting projects involve financial statement preparation and data reconciliation:
Built a 3-statement financial model using over 25 journal entries.
Ensured 100% reconciliation across trial balances.
Conducted adjustments and closing entries, improving accuracy by 20%.
Marketing Report: Burgify Sauce
Overview:
A comprehensive marketing report on Burgify Sauce, an innovative vegan-friendly burger sauce designed for the growing plant-based food market.
Projected first-year revenue: $812,000.
SWOT analysis and industry trends supporting product viability.
Competitive market positioning and pricing strategy.
Business Communication Assignments
Memo: Best Artificial Intelligence Writer
A comparative analysis of GrammarlyGo, Anyword, and ArticleForge, outlining their pros, cons, and best use cases.
Email: New Social Media Policy
A professional business email detailing a new corporate social media policy for Software Sales Corporation.
BCOM Essay
A structured business communication essay submitted for BCOM 3300.