วีดีโอ

thank you so much and i have some question. what if there is non stable lead time how can i manage it?

Thanks. For some reason the calculation is dollars of on my actual loan from the finance company.

Awesome, thanks.

Don't you think we should also consider inflation for the pmt it is not going to be 147679 for the next 25 years that amount should increase as well with inflation

ur so much better at teaching than my teacher

It's the same way to do a car loan?

Thank you! I can pay my car off early!

Why to take sqrt of lead time?

maybe a stupid question Calon, does this calculation make provision for monthly contribution increase on an annual basis perhaps?,

Excel is so powerful!!

Lacking explanation and moving to quickly through the steps.

I was thinking what went wrong with my model turning negative when having prepayments. Your explanation was right on point! Thanks for sharing!

Can you give me the reference of the Safety Stock formula. I can't find any relating to this . Thank you !

What do you think about this? I spent $3 everyday for a month. I got 6,500 views and 48 clicks. My best item has a 1.1% click rate which I think is not bad for just starting. Etsy is spending around $0.50 every day even though I have it set at $3 per day. Do you know why this is? Also if you have time it would be really helpful if you took a quick look at my shop and let me know what you think, and what I can do better. I own a 3D printing company. Here is the link: www.etsy.com/shop/Jacksons3DPC?ref=dashboard-header

Interesting how you calculated the dollars collected first vs going by unit price, estimating tax, then combining those as dollars collected. Thoughts?

THANK YOU!

Great explanation

Thank you! I need to make a few adjustments to this because i am not a sock salesman. But this is a great START!!

Can Etsy adds ruin me? conversion rate click rate etc . I’m one month in 736 views 6 orders, 310 visits and have 2% conversion rate. Can anyone help I think I shouldnt run ads while it’s quiet and while I’m getting the Etsy bump because if I get so much more views and no sales won’t it ruin my algorithm. Thinking I should slow it until 4th quarter. Any thoughts ??? Side note I only sell shirts and hoodies and have 118 listings and am not pushing anyone to site anywhere just yet

This is total fuccking bullshiiit. I been doing this for years and years, surveys alone are like 15 + minutes long and the most you can even get if you are lucky is $5 but you are going to get disqualified from a lot of them so in an hour you could make just $1.

I would literally give it all away to the needy.

Good info! Thanks

You saved my life! SO knowledgeable I love how you get to the point and make it simple. New subscriber!

Where's the previous video?

Great video!!! In the beginning of the video, I’m still a little bit confused on what the formula was to come up with the $539.06 payment…..

This was legit! I was looking for something like this and being able to keep track at home in an Excel spreadsheet. Appreciate you man

How do you account for one time costs in a pro forma?

Clear and helpful

I like your vids, but you also gotta realize, you posting on youtube will increase your traffic to etsy since its in your description, most people won't do that. So for anyone to get results like yours or anyone else who posts thesew types of vids on youtube, they too will also have to post on youtube or have some other stream of traffic

How do you make a one-time purchase of this program / software so you don't lose amortization spreadsheet due to internet glitch and subscriptions 🤔

I want to ask you something important... ROP means when you determine the stock level is undet rop you order EOQ... but if we have some orders will come and have productions that i will use the stock item... do we need to calculate the exact stock level like today stock+orders-production???

Started out great. You move way too fast, which is fine because I can pause and rewind. However, you assume, for example, at marker 3:18, I know how to "lock the sum". Since I cannot see your keyboard, I have no idea how you filled the payment column and what "function" you used. Also, I don't understand why "extra payments" shows up in cell C11. Moving on to another channel.

good day sir. just trying my luck really, really hope you or someone replies to this comment. how do do you add the lock so that you can project the correct number every time?

Hey Calon , very good video . I can do better editing in your videos which can help you to get more engagement in your videos . Pls lmk what do you think ?

This was very helpful, thank you.

I needed this!! Thanks for the help

Optimize your listings: 1 Use all available image slot 2 Simple title 3 ad video 4 use all available tags 5 use chat gpt for description :) 6 Use bing for ads

Thank you :)

It’s interesting, thanks for posting. Though I had really different results on 3D models, i have 10x the revenue. One thing I couldn’t figure out if Etsy ads worth or not. It’s just I always break even, even if it’s 1-5-25-50 USD a day 😅

Like the vid, good update keep it up

Awesome thank you!!

If I pay my payments early my interest rate fluxuates

This was perfection - thank you.

How would you calculate safety stock after a downstream process in the same value stream? Would you calculate lead time from the beginning or from the previous safety stock?

you aré suck for this business

I was looking at some tutorial videos on how to create a Loan Amortization Table, and I found this is the best one! Thank you Calon

Good to know. Love Etsy but it’s hard. Thanks for sharing!

Audio is extremely low, but great explainer otherwise

CAN YOU MAKE A COPY OF THIS EXCEL SHEET AND ADD THE LINK IN DESCRIPTION PLEASE?

Good info.