I’ve been stuck on an excel issue and I can’t seem to get it sorted out, tried YouTube, google, etc. I’m trying to run a PV calc on excel but I keep getting a different answer than my financial calculator. I = 4.75%, FV= 0, PMT= - 2501.13, N= 650 calc gives me PV of 955k, excel gives 951k - I cannot seem to get this to match, any suggestions?

My 401k technology stocks are down 27% as I started beginning of last year!
Hold and ride OR some other recommendation?

In the same day

Fidelity files for a bitcoin etf
Tesla let’s you buy their cars with bitcoin

I have got an offer based in Boblingen, Germany with 60k euro as fixed. Will it be enough for a couple with a 3 year old kid ? My major expense would be accommodation, groceries, kid’s school and transportation. Please do let me know your valuable inputs. TIA

Hello folks, any credit card suggestions with good benefits and cash-back? Please advise. TIA

Personal finance book recommendations?

There’s a debit card that I’ve been using for the past 4 years and it beats out some of the cash back credit cards. It’s the Cash app debit card. I haven’t heard people talk about it in the card community and it could save people a bit of money - 10% cash back. I posted about it on my Instagram HerMillennialMoney if you want to learn my tips and tricks with the care.

I just left my pre-seed startup that was running out of cash (we made $100,000 in revenue this year, and sunk $1m in costs). I was making $40,000 as a developer (plus 20k stock options at $1/share per year) and they refused to pay me any more money. I have 17,000 vested stock options, total number of shares at the time of my contract was 4million. I’m a bit confused about share dilution and if it’s worth it for me to buy some of my stock options… thanks in adv!

Any investors in the woodlands Texas for single family homes, rent looks good as per Zillow , good school district and houses are still affordable compared to Dallas and Austin

Cons of moving 75% of my savings to an Intermediate US Treasury ETF (SCHR)? I wouldn’t mind losing 4-5% if the market rallies, but would rather put cash to work if the market keeps tanking

I’m looking at investment a portion of my portfolio into alternative investments. Maybe around $30k to start. Anyone have recommendations or experience with Alt investment vehicles? (e.g., crowdfunded startups/real estate, PE, VC ETFs)??

New to US. Which brokers offer best margin accounts? For e.g. I have equities worth $100K and want to trade options. Is there a broker where I can do so without paying more in collateral money - essentially using stocks as collateral, and also not paying margin interest. Was able to do so in London, Hong Kong, and India. However, Robinhood here doesn’t seem to allow it.

Renting a car vs buying, which is better in India?

I have a client who needs a 401k, or a solo retirement account w loan options. When I was at UBS/Ameriprise, it was no issue but now it seems tougher to find a firm that does solo 401k as a RIA's.

One of my big hang-ups with biden tax plan is raising corporate tax across the board. Why raise taxes on businesses when we've just found out how fragile it is to be able to run a small business?Why not at least propose some kind of progressive corporate tax structure if you want to raise taxes on corps?

Final day at current company tomorrow and I have 100k+ AMEX points I need to use before they disappear forever. How should I redeem them to get the most bang for my buck?

Given the hot sellers market, do you guys think I should plan to sell my house on my own (private) vs get an agent? Want to minimize closing costs/fees. Thanks!

Happy New Year ! Anyone interested in bitcoin investment and NFT ?

Hi everyone

Is there any disadvantage if I get relieve on Friday compared to on Monday?

What I am thinking is I will be loss pay for sat and Sunday?

Actually my last is 27th
I asked for a week early relieving so thinking about this.

Thanks.

Best side jobs for extra money? Really need to supplement my income..

Tips for 6-month eval? Originally hired at 35K as assistant and was told if I performed well, I could expect to make 50K after a year. After one week, the operations manager resigned and I took over as a trial. Officially am operations manager, but no title (only verbal) and no raise. Owner likes benefits over big pay raises. Thinking about asking for 46K, new cellphone and official title change. I'm expecting some negotiating, which I've never done. 24F, AA Bus Admin, and overall good employee

How much difference does have a LinkedIn profile pic have vs not having it?

I’ve noticed that the are a few companies that aren’t performing a drug test as part of their onboarding, does anyone know if Microsoft are performing them at the current moment?

Base for qualtrics is really low - can someone assist?

How much salary is offered to director and senior director ?

Prospecting Ae’s (or bdrs) are you getting a lower open rate/filtered by spam filters due to attaching a link, screenshot or pdf? If yes, I’m curious if it’s the same drop off rate for all or if it’s different

Looking to transfer my lease to someone, as I’m moving for a new job. 2 bed, 2 bath top floor unit off Callowhill and 15th for $2626 per month, move in ~12/1. It’s on the end of the building, so living room and bedroom are corners, tons of natural light. Fitness center, golf simulator, rooftop grills, concierge, the works. Let me know if you or someone you know are interested!

Hello guys,

Is landmark health technologies acquired by Optum, because I got offer from landmark health technologies and they are saying it's acquired by Optum?

Thanks in advance...

Definitely going to be a noobie question!

My client's medical provider asked for his PIP ledger: how do I get that? Just send a LOR to the carrier and ask?

Any good stories from 2008-2010?

EY advisory laptops - do you get to choose a model or is one just randomly assigned to you?

Received an offer for equity research and IB, both in toronto. ER paying $120k base and my understanding is that bonus can be around 25-30%. IB is paying $105k base but likely higher bonus? Which one would u choose if you think you would be good at both

Republicans who voted biden: who are you voting for in January?

Can anyone please advise on Sullivan & Worcester? Is it comparable to Big Law in terms of salary/quality of work and quality of life?

How is Tech Mahindra for legal counsel role? What should be the package for a person with 4 years of experience?

Internal strategy teams at banks, what’s an acceptable range for a 1st year Director? Total comp? Pretty sure I’m getting short changed...

Hey I’m a recent grad in business marketing. I have a lot of experience with customer service and sales. I recently have gained experience in minor recruitment roles but definitely willing to learn and venture out into the tech field.

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

Any book recommendations on excel modeling for real world business applications?

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

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

Would anyone be willing to teach me vlookup?

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?

How do I compare two sheets to make sure they are identical?

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?