Financewalk Logo (Text)

The FinanceWalk Blog

We help you get better in your career: detailed guides, case studies, and career coaching advice from top career coaches.
How to Use Excel for Finance: The Best Guide

Welcome to Excel for Financial Analysts post. Many of you might be wondering why this post? Why a separate excel post for how to use Excel in financial analysis? What’s so special about it?

Read More
How to Do DCF Valuation Using Sensitivity Analysis in Excel

In this post, we are going to see Sensitivity Analysis in Excel. Discounted Cash flow is probably the commonest way of valuation of a company. This method involves amongst other things analyzing the impact of factors like cost of equity or change in risk-free rate on the price of a company’s share. It is but […]

Read More
Sharpe Ratio Excel: Formula and Calculator Guide

In this article, I’m going to explain how to calculate one of the most famous ratios, among financial analysis, to measure risk in Microsoft Excel: the Sharpe Ratio Excel. The Nobel laureate William F. Sharpe developed the Sharpe Ratio. According to Investopedia: “The Sharpe ratio is calculated by subtracting the risk-free rate from the return of the portfolio […]

Read More
© 2020 - FinanceWalk