I need some help . I’m trying to find the formula that will help me create a calculator of some sortes . Im trying to take my current cost add my margin % then add taxes and fees . After that I would love to have a drop down that has my financing options and when I click on it . It auto populates that price with financing . And then the price with out it . Thank you

like
Posting as :
works at
You are currently posting as works at

1) Have a place for your inputs:
Cost, tax rate, fees, margin %

2) Have a place for the formula:
(Cost + (cost * margin %) + fees) * (1 + tax rate)

3) Have a place for financing options referencing the output of step 2. You can use hardcoded values or inputs as well for the term and interest. Use =PMT() formula for payment calculations.

helpful

Sounds like you do the math with equations for however the several financials options could be and then whatever your drop down says, that gets index matched in, etc, etc

Grab an income statement template.
Build it, then use data validation > list to get your drop down.
Reference that fell with any subsequent financing formulas or amortization.

Related Posts

How much should I invest in buying a HOME as my primary residence.

Current TC: 200k
Net worth: 300k, readily available 170k in stocks, hysa and cash
Current rent: 2000 per month
Age: 30

Wonder if anyone has any excel model or a rule to determine how much I can afford or should go for?

like

Hi everyone, any tips for resignation letters, who to meet/tell first, what to do before your last day (i.e. anything adulty like 401K or healthcare)? Any insights would be greatly appreciated!

like

Hi fishes,

Please help me find out my take home salary and how to save maximum in tax. I am really new to this tax regime and not aware how to save taxes.
Please help.

Post Photo
like

Fixed ctc 2435000 Lpa with gratuity 3.5k pm and pf including both employer and employee 16k pm. Any estimated what will be take home pm post tax?

like

How much money do you have saved up?😳

like

In the past I’ve wrongly thought that forgiveness brings restoration of relationships. But reconciliation requires everyone involved to respond -which is beyond our control. Forgiveness says I’m canceling that debt- it’s my marker & I’m tearing it up. I’m putting myself in Gods hands -Justice comes from Him. We mistakenly think that forgiveness is weakness as if we just capitulated. Forgiveness isn’t a sign of weakness- It takes strength to forgive. God tells us to forgive.

Post Photo
like

First instinct this morning... put more money on coinbase. Hope by the time it clears I still catch the bottom.

like

Hi everyone! Looking for some advice on my side hustle. I’m running an e-commerce store selling primarily home decor, and I wanted to get some honest feedback & suggestions on the site to see what I can improve for better conversions. I’ll leave the link in a comment for anyone who would like to take a look.

like

I'm a long time user of mvelopes budgeting software, and we just got a notice that they're shutting the platform down at the end of the year.

Looking for a recommendation for an "envelope based" replacement. They suggested Every Dollar, but it doesn't handle credit cards well.

like

My wife and I use a joint account for managing our monthly expenses. Can we both use UPI IDs linked to this account on our respective phones ?

Personal finance book recommendations?

like

From a financial standpoint in this market, which would be a better approach in Austin -

1. Buy a ~8-850k house that meets most of our ideal criteria (size, schools, interiors etc) to stay long term

2. Buy a ~5-550k house that’s not ideal with the plan of moving into an ideal home in 4-5 years when kid is ready for school.

How easy is it to get a mortgage for the second home?

Household income - 300k

Happy to add more details as needed

Thanks

Will be moving to LA at the start of next year. I make $150k and my boyfriend freelances and averages around $60k. How much should we realistically be paying in rent max?

like

Is there any way to get around the coinbase fee when buying crypto?

like

How do you manage your money?

I only bring in a little over $2,600 a month. After paying all my expenses, I get to put away $500 a month in savings but don’t have much wiggle room for anything else, including going out money.

I’m very privileged to have a significant inheritance and zero debt of any kind. I really wonder how my peers who have student loans, car payments, and even children manage to pay their bills and live so comfortably. Please share if this is you!

like

Anyone ever use a credit repair service and have success?

FYI Amex offer for Allen Edmonds. Spend $300 get $90

like

In chamath we trust. This guy prints money. The wave will end eventually but damn it has been good.

like

How do you guys invest in US equities. Obviously wealthsimple trade is a scam.

In a perfect world how much would you want to make a year to both pay off your loans and live a good life? I think I'd need to make upwards of $200k to pay off my loans, take care of my family and live a fulfilling life.

like

More Posts

35 Single male, in DFW area, looking for female for fun and companionship. I love eating good food, traveling, Reading books.

likefunny

Anyone looking for a male flate mate in Pune please DM

Haven’t done the dating thing in a while so need advice! (F here) Met a guy at a party on Sat, followed each other on insta, then I dm’ed him my number saying “lmk if you want to get drinks sometime”. He then texts me and says something along the lines of “yeah let’s do it” but doesn’t offer any concrete plan. Does this mean he’s not super into it? Or am I overreacting and I should initiate the plan? I initiated the insta follow and the dm so I feel like it’s his turn…?

like

How’s your expirience of going to deloitte Usi Pune office? Actually I want to go for 2 weeks in office

like

Are any of your firms providing vaccine exemptions?

like

Looking to get some new knives to rebuild my set. Interested in brands and types of knives y’all are cooking with

like

Hi guys ,
Which is best among CGI and HCL for automation testing role?

like

Sanity check. I like a nice lifestyle. Currently make 350-550k with bonus. 53 years old. About 400k in brokerage. Another 1.9million in retirement accounts. House worth 1.2 million with loan of 625k. For retirement pension will be $2400 per mo which goes to my wife if I die for life. Another 3800k Per month estimated from Social Security. I plan on working another 10 years or so maybe less once the kids graduate college. I am this will be out in 2024. What should I be doing or thinking about? 

like

Has anyone regretted their decision to become a PA instead of a Physician because we end up doing mostly the same work but for less pay? I'm considering the extra education

like

I’m discussing a part-time orthopedic position that would include clinic and surgery in WA state, about 1 hour from seattle. 5 years experience. Anyone have experience with this? I’m looking for hourly rate expectations. I will be covered under their malpractice insurance, but no other benefits.

like

Coming out at work by bringing my girlfriend (serious) to our firm outing!!! Nervous but ready to be happy and open!

likeuplifting

What do you guys think of Magic Circle firms? Should I join them instead of another top 30 AmLaw firm?

like

Hello

Is there anyone who is to join Morgan Stanley for technology analyst this year and will be a part of 3-4 months training?

Also, is this training virtual or physical? If physical, then Mumbai/Bangalore?

like

Hi guys , i need referral ,,
Any help would be appreciated
Thanks in advance,, drop a comment pls

like

Any houston folks here?

like

Good Morning Everyone,

I hope everyone’s week has been going well. I applied for the Business Development Manager - Platform Partnerships with Square for Zone B.

Would there be someone willing to point me in the right direction or refer me?

Thank you in advance.

like

... and I was hoping ltc would hit 1000... losing money right now 😵😵😵but hodling

Any folks who’ve recently started the game that could use DIYs? I have amassed a bunch that could be offloaded

like

Hello,
I work in SAP Data Migration space.
Can anyone explain the difference between PWC SDC, PWC AC and PWC India?

I am trying to get into PWC. here are a few things I have heard so far. Is this fairly accurate?

1. PwC AC is offshore counterpart of PwC US. Good salary. No travel opportunities. Average yearly hike ~10% Mostly technical work.
2 PwC India is a pure consulting firm. Salary better than PwC AC. client facing work. Can grow as a management consultant. Great Travel opportunities.

like

I am looking for payroll with hr support system. ADP is too expensive. Any other suggestions? Thank you.

like

Additional Posts in Excel Genius

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Still don't have xlookup. #fomo

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal