课程: Excel Modeling Tips and Tricks

免费学习该课程！

今天就开通帐号，24,600 门业界名师课程任您挑！

Setting up a multi-sheet financial model

Setting up a multi-sheet financial model - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

开始一个月试用 购买团队方案

Setting up a multi-sheet financial model

“

- [Instructor] So far, we've been talking about relatively simple Excel models, Excel models involving only a single sheet. But for many different issues that we're trying to model in the real world, we might need to use multiple Excel sheets. Let's take a look at an example. I'm in the 03_01_Begin Excel file. Now, what we have here is an income statement and a balance sheet for a fictional firm, RedTech 30, and we see that we've got revenue numbers and net income numbers from the period 2021 through 2024 for the full year. Now, what we want to do is go through and build a forecast for 2025 and beyond. So, how do we go about actually doing that? Well, we're going to use more than one Excel sheet. We've got our income statement, our balance sheet, on separate sheets to begin with, and we're going to pull into a third sheet our forecast sheet from those first two. So, for example, the number of phones sold. Well, this is going to come from the income statement, line B18. Here's our…

内容