# \#excel

**URL:** https://kb.cremodels.com/tag/excel/2.md

[Latest](https://kb.cremodels.com/latest.md) · [Categories](https://kb.cremodels.com/categories.md) · [Tags](https://kb.cremodels.com/tags.md)

---

## [Multifamily Acquisition Template - Loan Sizing](https://kb.cremodels.com/t/multifamily-acquisition-template-loan-sizing/511)

<div class="topic-metadata">

**Author:** [@MaxGarbus](https://kb.cremodels.com/u/MaxGarbus)\
**Replies:** 0\
**Last updated:** [February 21, 2020, 11:07pm UTC](https://kb.cremodels.com/t/multifamily-acquisition-template-loan-sizing/511 "2020-02-21T23:07:32Z")

</div>

Please see below for instructions on the loan sizing inputs in our debt assumptions section. This allows for loan sizing based on LTV and Cap Rate, Debt Yield, and Debt Service Coverage Ratio.

---

## [Enable Iterations in Excel](https://kb.cremodels.com/t/enable-iterations-in-excel/466)

<div class="topic-metadata">

**Author:** [@MaxGarbus](https://kb.cremodels.com/u/MaxGarbus)\
**Replies:** 0\
**Last updated:** [February 12, 2019, 2:37pm UTC](https://kb.cremodels.com/t/enable-iterations-in-excel/466 "2019-02-12T14:37:37Z")

</div>

Please see below directions from Microsoft Office support as a reference for enabling iterations: 1A) If you’re using Excel 2010 or later, click File \> Options \> Formulas. If you’re using Excel for Mac, click the Excel …