Question: This is excel assignment and I have no idea. Could you guys solve this problem with explanation( I need excel formula!) Project IB Sample (1)(i)

This is excel assignment and I have no idea. Could you guysThis is excel assignment and I have no idea. Could you guys solve this problem with explanation( I need excel formula!)

Project IB Sample (1)(i) Home insert Page Layout Formulas Data Review View ace Precedents E Define Name Trace Dependents insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Show Error Calcu Create from Selection x Remove Arrows Formulas Checking opt Function sed Time Reference Trig Functions F1 1 You need to make a decision below: 2 Your rich uncle decided to give you 2 options to pick: 3 A. He is giving you $12,000 right now, no strings attached 4 B. He will be giving you $3,000 a year for the next 4 years 5 Now the bank is giving you 4% CD (Certificate of Deposit) 7 Your rich aunt also wants to giving you 2 options: 8 C. Instead of giving you money now, she wants you to wait 9 until 5 years later. She will give you a lump sum of $10,000 10 D. She is also giving you this option: $2,000 a year for the next 11 5 years. Now the interest from the bank is 5% 12 Additional question: 13 Would you change your mind if the bank's interest is 6%? 14 15

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!