giống như trong hình Bước cuối cùng là áp dụng vượt quá đó chỉ là tính toán để hiệu trưởng cấp cao. Sửa đổi công thức trong tế bào dư nợ cao cấp cũng giảm theo định lượng Nếu có bất kỳ dư thừa áp dụng cho hiệu trưởng cấp cao của nó sẽ làm giảm sự cân bằng phù hợp. Sao chép và dán công thức này trên phạm vi | Analytics and Output Reporting 135 OUTPUT REPORTING Most people do not have the time to sift through the minutiae of a complex financial model. Users of financial models generally want an understanding of results pertinent to their decision-making process. A majority of these results can be summarized in one page. This single page known as an output report most efficiently conveys a cash flow model when it is split into three separate sections scenario assumptions cash flow snapshot and charts. Figure provides a general overview of an output sheet. These three sections make it easy for a person to quickly see what assumptions were put into the model what the results are for important periods in the cash flow and how certain data intensive assumptions results look graphically in charts. An important part of the output report is that it will be created as its own worksheet in the model and should contain as few entered values as possible. This means that nearly all of the sheet should reference parts of the model. The reasoning behind this is that as assumptions and results change per scenario the output report should automatically update. Errors usually occur when a scenario is run but the output sheet is not updated. By using as many references as possible there will be fewer possibilities for an error and an increase in model operation efficiency. FIGURE The output sheet has three distinct sections Scenario Assumptions Cash Flow snapshot and Charts. 136 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL MODEL BUILDER CREATING THE OUTPUT REPORT 1. The first step to creating the Output Report is to make a section on the Inputs sheet for reporting parameters. On the Inputs sheet enter these labels in the following cells G28 Reporting Parameters G29 Scenario Name G30 Beginning Snapshot Start G31 Ending Snapshot Start 2. For now enter Base Case in cell I29 and name it ScenName. Enter 0 in cell I30 and name it SnapshotStart. Finally enter 350 in .
