1 answer

Using Excel to calculate the following: 1. The future value of $3 invested every day, 360...

Question:

Using Excel to calculate the following: 1. The future value of $3 invested every day, 360 days per year, for 50 years at 8% i

Using Excel to calculate the following: 1. The future value of $3 invested every day, 360 days per year, for 50 years at 8% interest. Hint: Interest is compounding daily. 2. The future value of $1,080 ($3 x 360) invested annually for 50 years at 8% interest. 3. The payment for a mortgage with a principal amount of $150,000, an interest rate of 5%, fully amortized over 30 years. 4. The price today of 15 year bond that has a face value of $10,000, matures in 10 years and pays a coupon interest rate of 10%. Interest is paid semi-annually. 5. Based upon your answers from numbers 1 and 2 above, would you rather save $3 per day or $1,080 per year. Explain your answer in three sentences or less. Hint: Think about the effect of compounding interest.

Answers

1)

Function Arguments ? X FV 1 1 = 0.000222222 = 18000 Rate 8%/360 Nper 50*360 Pmt -3 pro Type o 1 = 0 = 723247.5578 Returns the

Hence, Future value is $723,247.56

2)

Function Arguments FV Rate 8% Nper 50 Pmt -1080 Pro Type o 1 1 1 = 0.08 = 50 = -1080 = 619671.7689 Returns the future value o

Hence, Future value is $619,671.77

*Please rate thumbs up

.

Similar Solved Questions

1 answer
Question 5 Which arrow points at a peptide bond? 1 R 3 2 Hydrogen bond R...
Question 5 Which arrow points at a peptide bond? 1 R 3 2 Hydrogen bond R Arrow #3 Arrow #2 Arrow #4 Arrow #1...
1 answer
Evaluate the integral below by interpreting y=f(x) it in terms of areas in the figure. A1...
Evaluate the integral below by interpreting y=f(x) it in terms of areas in the figure. A1 АЗ The areas of the labeled regions are 10 31 5 A2 7A4 10 A1= 7, A2=4, A3=2 and A4=2 (figure is NOT to scale) v= 5.5" f(a)de V = Enter your answer as a whole number...
1 answer
1. Consider the following sample data: (2, 5, 12,19,21,25 38, 52,65, 69,99). Calculate the following using...
1. Consider the following sample data: (2, 5, 12,19,21,25 38, 52,65, 69,99). Calculate the following using appropriate symbols when possible. a. Mean: b. Median: 2/S C. Standard Deviation: 21.3° ะ d. Variance: 30.78 =52 e. Range: 7 f Midrange 8. Q1: 2 i. Q3:し Lower fourth: 2 3 k. Up...
1 answer
How does luminosity differ from the brightness of the same object as seen at the earth?
How does luminosity differ from the brightness of the same object as seen at the earth?...
1 answer
On January 1 of the current year, Aladdin Company paid $900 rent to cover six months...
On January 1 of the current year, Aladdin Company paid $900 rent to cover six months (January through June). Aladdin recorded this transaction as follows: Journal Entry Debit Accounts Credit Date Jan 1 Prepaid Rent 900 Cash 900 Aladdin's adjusting entry at the end of February included a debit to...
1 answer
Can someone please help. what is missing in my answer? The following are the ending balances...
can someone please help. what is missing in my answer? The following are the ending balances of accounts at December 31, 2021, for the Valley Pump Corporation. Account Title Credits Cash Debits $ 34,000 74,000 99,000 $ 19,000 62,000 138,000 345,000 109,000 93,000 34,000 Accounts receivable Inv...
1 answer
Problem 1: Suppose we survey 500 students about their opinions on different sports leagues. We find...
Problem 1: Suppose we survey 500 students about their opinions on different sports leagues. We find that 215 students like the NFL, 305 students like the NBA, and 170 students like both the NFL and the NBA. a. Complete the Venn Diagram: b. How many students don’t like either the NFL or the NBA...
1 answer
A direct mail company wishes to estimate the proportion of people on a large mailing list...
A direct mail company wishes to estimate the proportion of people on a large mailing list that will purchase a product. Suppose the true proportion is 0.07. If 310 are sampled, what is the probability that the sample proportion will differ from the population proportion by more than 0.04? Round your...
1 answer
Asteroid Bearcat has a orbital period of 2000 years. What is its semi-major axis in AU?
Asteroid Bearcat has a orbital period of 2000 years. What is its semi-major axis in AU?...
1 answer
The details of a share are given. The recent dividend it has distributed is D0=2 €,...
The details of a share are given. The recent dividend it has distributed is D0=2 €, equity cost ks=13%. The dividend is expected to grow steadily at a rate of 6%. Calculate what will be the share price 2 years from today?...
1 answer
HAPTER 8 Receivables, Bad Debt Expense, and Interest Revenue LO 8-3 ?8-10 Using the Interest Formula...
HAPTER 8 Receivables, Bad Debt Expense, and Interest Revenue LO 8-3 ?8-10 Using the Interest Formula to Compute Interest Complete the following table by computing the missing amounts (2) for the f dent cases. MB-16 Principal Amount on Note Receivable Time Period 6 months 9 months 12 months Annual In...
1 answer
For a standard normal random variable, what z-score has (a) probability 0.175 to the right? (3...
For a standard normal random variable, what z-score has (a) probability 0.175 to the right? (3 decimal places) (b) probability 0.950 to the left? (3 decimal places)...
1 answer
A certain element emits a Kalpha X ray of 0.055 nm wavelength. Identify the atomic number...
A certain element emits a Kalpha X ray of 0.055 nm wavelength. Identify the atomic number Z of this element. Z (integer)...
1 answer
What is obsidian?
What is obsidian?...
2 answers
How many isomers can a formula of #C_4H_10O# generate?
How many isomers can a formula of #C_4H_10O# generate?...
1 answer
How do you solve #9^x=45#?
How do you solve #9^x=45#?...