---
title: "Excel Model: Muni Yield Calc Using Newton"
description: This video shows how to use the companion free Excel model to determine a municipal standard yield using Newton's method.
---

[![Intuitive Analytics logo](https://www.intuitive-analytics.com/hs-fs/file-2107809522-png/images/logo-1.png "Intuitive Analytics logo")](https://www.intuitive-analytics.com/) [![Intuitive Analytics logo](https://www.intuitive-analytics.com/hs-fs/file-2113006844-png/chrome/intuitive-analytics_logo.png "Intuitive Analytics logo")](https://www.intuitive-analytics.com/)

Go

[![Client Login](https://www.intuitive-analytics.com/hs-fs/file-15740396-png/images/cta-clientlogin.png "Client Login")](http://users.exposuremgmt.com/)

# Excel Model for Muni Yield Using Newton's Method

This video walks through how to use the free Excel Model from [Intuitive Analytics Resources](https://www.intuitive-analytics.com/Resources/clients/) to calculate municipal and public finance standard yields (30/360 daycount, semi-discounting). When working on spreadsheet models this technique avoids repetitively invoking goal seek and keeping your workbook fully calculated and current at all times. 

© 2017 Intuitive Analytics LLC. All rights reserved.  
[Privacy Policy](https://www.intuitive-analytics.com/privacy-policy/)

**Various products, solutions, methodologies, processes and techniques presented and/or described on this website are proprietary to Intuitive Analytics LLC, and are multiple patents pending.*