Past Work
Welcome to my Project Page! Here, you'll find an overview of my latest college projects, showcasing the skills and knowledge I’m developing in finance and business. Each project represents a deep dive into real-world applications, where I analyze, strategize, and problem-solve. Feel free to explore the details and gain insight into the context, background, and objectives of each project.
Industry Report
I aimed to present a clear and detailed analysis of the financial state within a specific industry, capturing key trends and insights. My goal was to break down complex financial data into accessible components, focusing on assets, liabilities, and equity to provide a comprehensive view of the industry's financial health. By including comparative figures across multiple periods, I wanted to emphasize changes over time, allowing readers to spot trends that may signal growth opportunities or potential risks.
Financial Excel Assessment
In this finance Excel assessment, I developed two loan models to analyze the balances and interest expenses for a 20-year loan of $235,000 with a 3.4% interest rate. The objective was to track monthly payments using two different approaches: one model calculated the loan using an Annual Percentage Rate (APR), while the other applied an Effective Annual Rate (EAR). By applying Excel formulas effectively, I determined the monthly and annual rates, along with the total interest expenses under both APR and EAR conditions. This exercise deepened my understanding of loan amortization schedules, interest rate compounding, and reinforced my ability to apply Excel to financial analysis, which will be beneficial for future roles requiring quantitative finance skills.
Final Communication Plan
The presentation, "Fueling Celsius’ Engagement," outlines a strategic plan to enhance Celsius's brand presence by addressing communication gaps with key stakeholders. The team proposes updates to the company's website and a targeted social media campaign on platforms like TikTok and Instagram, aiming to reach 460 million consumers and boost engagement by 50%. With a budget of $140,425, allocated to professional hires and ad spending, the project leverages benchmark analysis and clearly defined KPIs to guide execution, presenting a well-structured approach to driving Celsius's sales and digital engagement.