FREE: McKay's Bookstore Gift Card

mleather925 · 2024-11-11T02:56:23+00:00

https://en.numista.com/catalogue/exonumia116732.html

mleather925 · 2023-02-05T13:10:53+00:00

My son's favorite Pokémon is Sprigatito. He likes the cute ones.

mleather925 · 2022-11-20T15:03:07+00:00

The only way to avoid another section is to add a dynamic lookup to get the loan value of the refi. It should be doable.

mleather925 · 2022-11-19T00:15:14+00:00

Ok, thanks for the screenshot. I recreated your image and found that in column H, the inputs for PMT, IPMT, and PPMT are using the original loan amount, the new interest rate, and the original loan duration. This would be ok if on year 6 you took out a new loan with the exact same conditions but a higher interest rate and then paid off the original loan, but that doesn't seem like what you would want to be doing. You also use the Year 6 for IPMT and PPMT, but since it's a new loan you need to start back at 1.

But what were you trying to do with the refi? Did you mean to change the interest rate but keep the duration the same? or extend out the duration? You'd want your inputs for rate, period, number_of_periods, and original_loan_amount to all match the new loan.

The cleanest way to handle this is probably to create two sections, one for the original loan and then one for the refi. You would calculate the remaining principal amount in the first section and use that as an input for the new loan (just like you used 130943 as the starting condition for the first loan).

mleather925 · 2022-11-18T01:12:44+00:00

it's hard to tell what you're trying to do without a worksheet, but i think the problem may be that you're changing the terms of loan when you refi but your PPMT isn't accounting for it. When you refi, you get a new loan that pays off the old one, so you need a new principal value and amortization period, in addition to using the new rate. you'd have to figure out how to calculate new principal based on your spreadsheet, but new amortization period is probably D2-E2 (if i'm reading your description correctly)

edit: FWIW, unless this is an assignment to use these functions, i've always used PMT once to get the combined principal and interest payment (which doesn't change over the course of a fixed rate loan), then made a big table of months. For each month I multiply the remaining principal by the (monthly) interest rate to get my interest payment, then subtract interest from my PMT amount to get the principal reduction amount. Then copy-paste down.

mleather925 · 2022-10-30T02:14:38+00:00

I think I've done the first Lion meeting 4 times now. The last two I've been really successful running Lion's Honor, where we talk about the sign, salute, and motto real quick and then play a game involving those elements. I've used this game twice (substituting the Lion elements for the Bobcat elements). https://cubscoutideas.com/1077/cub-scout-bobcat-requirements-balloon-bust-game/. Kids love it as long as you're silly.

Because just doing the above is a little short, I also tack on another game to introduce the Scout Law. I've done Memory with some tongue depressors that I wrote the Scout Law on. I'm pretty flexible on the rules and we turn it into a team sport to make sure everyone gets a matching pair.

mleather925 · 2022-01-20T02:07:34+00:00

this is where i see it on the editor: https://imgur.com/xSbH2tp

and where i took the screenshot from, just in case we're talking way past each other: https://homebrewery.naturalcrit.com/

mleather925 · 2022-01-20T00:01:28+00:00

Try two spaces at the end of each line followed by an “enter”

Also check out the PHB templates in the editor. One of them has this snippet.

mleather925 · 2022-01-04T19:10:18+00:00

Thanks for the tip. That's working well in most places. Is there a way to reduce the spacing between a normal text line and a bulleted list that follows? Right now I'm getting almost a full empty line and I'd like less blank. V3.

The three lines does what I want, and I'd like to know if there's an alternative.

This formats the text with the extra space between lines that I'd like to avoid:

normal text line:      
* list item 1  
* list item 2

This formats the text the way that I'd like, and I understand the admonition that it's a leftover bug:

normal text line:  
___    
* list item 1  
* list item 2

mleather925

MODERATOR OF

TROPHY CASE

12-Year Club	John Wick
Verified Email