Mediaspace scheduled maintenance: Aug 25, 2026 07:00 - 12:00 AM. During this time, videos will be temporarily unavailable. Check status updates.

Lecture

Financial Analysis: Excel Exercises

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 (19)

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 (31)

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.

Project Evaluation: Financial Analysis

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

Comparative IRR Analysis

Explores the internal rate of return concept through a comparative analysis of investment scenarios.

Financial Investment Analysis

Delves into financial investment analysis, emphasizing real estate and financial investment profitability assessment.

Hydropower Market Overview