Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve the questions on Microsoft Excel 1. You want to set aside 5% of your income from your bi-weekly paycheck and watch it grow.

image text in transcribed

Please solve the questions on Microsoft Excel

1. You want to set aside 5% of your income from your bi-weekly paycheck and watch it grow. If you wanted to know how much money that would be worth in 5 years, would you use present or future value? 2. What is the present value of $792 four years from now using a 3% discount rate? 3. What is the future value of $500 in 35 years if you receive an 8% rate of return? 4. If you receive monthly bank interest of .08\%, how much would $1,000 be worth 3 years from now? 5. You received a $100 Treasury bond from your grandfather. It will mature (acquire the full value of $100 ) in 30 years. If you assume that your grandfather will get a guaranteed 3.5% rate of return, how much money must he have paid for the bond

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SAP Audit Black Book

Authors: Bhushan Jairamdas Mamtani

1st Edition

9351194086, 978-9351194088

More Books

Students also viewed these Accounting questions