Lecture

Financial Analysis: Excel Exercises

Graph Chat

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.

Description

This lecture covers various financial analysis exercises using Excel, including calculating present value, total revenue, and direct yield rate. Students will learn to manipulate data, apply formulas, and analyze scenarios for financial decision-making.

Official source

Related concepts (24)

Present value

In economics and finance, present value (PV), also known as present discounted value, is the value of an expected income stream determined as of the date of valuation. The present value is usually less than the future value because money has interest-earning potential, a characteristic referred to as the time value of money, except during times of zero- or negative interest rates, when the present value will be equal or more than the future value. Time value can be described with the simplified phrase, "A dollar today is worth more than a dollar tomorrow".

Net present value

The net present value (NPV) or net present worth (NPW) applies to a series of cash flows occurring at different times. The present value of a cash flow depends on the interval of time between now and the cash flow. It also depends on the discount rate. NPV accounts for the time value of money. It provides a method for evaluating and comparing capital projects or financial products with cash flows spread over time, as in loans, investments, payouts from insurance contracts plus many other applications.

Financial modeling

Financial modeling is the task of building an abstract representation (a model) of a real world financial situation. This is a mathematical model designed to represent (a simplified version of) the performance of a financial asset or portfolio of a business, project, or any other investment. Typically, then, financial modeling is understood to mean an exercise in either asset pricing or corporate finance, of a quantitative nature. It is about translating a set of hypotheses about the behavior of markets or agents into numerical predictions.

Time value of money

The time value of money is the widely accepted conjecture that there is greater benefit to receiving a sum of money now rather than an identical sum later. It may be seen as an implication of the later-developed concept of time preference. The time value of money is among the factors considered when weighing the opportunity costs of spending rather than saving or investing money. As such, it is among the reasons why interest is paid or earned: interest, whether it is on a bank deposit or debt, compensates the depositor or lender for the loss of their use of their money.

Financial analyst

A financial analyst is a professional, undertaking financial analysis for external or internal clients as a core feature of the job. The role may specifically be titled securities analyst, research analyst, equity analyst, investment analyst, or ratings analyst. The job title is a broad one: in banking, and industry more generally, various other analyst-roles cover financial management and (credit) risk management, as opposed to focusing on investments and valuation; these are also discussed in this article.

Related lectures (32)

Real Estate Economics: Comparing Renting and Buying MOOC: Soil and Real Estate Economics I

Explores the financial aspects of renting versus buying real estate properties over a 2-year horizon, comparing costs, cash flows, and resale values.

Investment Valuation: Present and Future Value Concepts

Explains present and future value concepts in investment valuation, emphasizing their calculation and significance in financial decision-making.

Project Evaluation: Financial Analysis

Discusses project evaluation through financial analysis, covering rental income, adjustment rates, and net present value calculation.

Investment Decisions: Annuities and Discounting Costs

Covers investment decisions, focusing on annuities, discounting costs, and evaluating profitability through net present value and internal rates of return.

Energy Economics: Payback Period and Investment Analysis