Suppose that you are planning to buy a boat in in 28 years [cell B3] for...
| Suppose that you are planning to buy a boat in in 28 years
[cell B3] for $100,000 [cell B2], and you deposit into your account
the amount of $26,000 CAD [cell B1]. |
| (a) | What average annually compounding rate of return (as a
percentage, correct to 2 decimals) should you earn so you can
accumulate the lump sum needed to achieve your goal [cell B5]? Use
the RATE function. (Note: You might have to modify the format of cell B5 so that it shows 2 decimals.) |
| (b) | What is the correct formula (using 18 characters or less) that
should be placed in cell B5? Note: There are to be NO numbers in the function call (apart from a 0 if appropriate), only cell references, or negative cell references where appropriate. |
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Add Answer to:
Suppose that you are planning to buy a boat in in 28 years
[cell B3] for...
17. Which formula in B5 will allow you to determine how many years it will take...
17. Which formula in B5 will allow you to determine how many years it will take to quadruple your savings at 11% compounded quarterly? a)NPER(B3/B4,0.-BI,B2)/B4 b) NPER(B3/B4,0-B1,B2) c)NPER(B3 B4,0-BI,B2/B4 d)NPER(B3/B4,0-B2,B1) B4 Present Value 2 Future Value 3 Interest Rate 4 Compounding Frequency 5 Number of Years s 3,000 12,000 11% 18. What solution would you get in cell B36? 3s Variable 4 Variable2 35 Variable 3 36 a) 3.333333 b) 1462.96 c) 123.703 d) -2453.85 e) 7606629.6 833 834-835 833/834...
Excel is allowed! For this lab, we will create a spreadsheet that allows somebody to type...
Excel is allowed!
For this lab, we will create a spreadsheet that allows somebody to type in a loan amount, interest rate, and length of the loan in years. The spreadsheet will then calculate the monthly payment required and the actual amount paid on the loan. First, setup your spreadsheet: • In Cell A1, put the label Loan Amount:. The corresponding value would be input in Cell B1. • In Cell A2, put the label Interest Rate:. The corresponding value...
Hello, i want to ask you Inventory cost =3.6(B1+B2)/2+3.75(B2+B3)/2+3.98(B3+B4)/2+4.28(B4+B5)/2+4.2(B5+B6)/2+3.9(B6+B7)/2, So, how to compute 3.6, 3.75, 3.98,...
Hello, i want to ask you Inventory cost
=3.6(B1+B2)/2+3.75(B2+B3)/2+3.98(B3+B4)/2+4.28(B4+B5)/2+4.2(B5+B6)/2+3.9(B6+B7)/2,
So, how to compute 3.6, 3.75, 3.98, 4.28, 4.2? And why 3.6X(B1+B2)
and divide by 2? Also, i want to ask the objective function for
this problem why is minimize, not maximize? Thank you for your
help!
The Upton Corporation manufactures heavy-duty air compressors for the home and light industrial markets. Upton is presently trying to plan its production and inventory levels for the next six months. Because of seasonal fluctuations...
If you bought a stock for $53 dollars and could sell it 16 years later for...
If
you bought a stock for $53 dollars and could sell it 16 years later
for three times what you originally paid. What was your return on
owning this stock?
PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A
PICTURE FOR AN EXAMPLE!
Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is...
In this project, you will work with sales data from Top’t Corn, a popcorn company with...
In this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will begin by inserting a new worksheet and entering sales data for the four food truck locations, formatting the data, and calculating totals. You will create a pie chart to represent the total units sold by location and a column chart to represent sales by popcorn type. You will format the charts, and...
Q1. Assume you are 25 years old today. If you wish to have saved $500,000 by...
Q1. Assume you are 25 years old today. If you wish to have saved $500,000 by the time you retire at age 65 (in 40 years), what monthly deposit must you make into your investment account assuming it will earn a fixed-rate return of 6.5%? Place the appropriate values in the proper cells in row 3, given the columns as provided below. Note, where relevant, present value answers should be shown as a negative number. Circle the answer. Provide the...
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has...
Ruiz Company issued bonds on January 1 and has provided the
relevant information. The Controller has asked you to calculate the
bond selling price given two different market interest rates using
Excel’s Present Value functions. Use the information included in
the Excel Simulation and the Excel functions described below to
complete the task.
Cell Reference: Allows you to refer to data
from another cell in the worksheet. From the Excel Simulation
below, if in a blank cell, “=B2” was entered,...
Chapter 10 Excel Saved Help Save & Exit Submit Ruiz Company issued bonds on January 1...
Chapter 10 Excel Saved Help Save & Exit Submit Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel's Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. 10 points (8 02:46:24 eBook Print References • Cell Reference: Allows you to refer to data from another...
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has...
Ruiz Company issued bonds on January 1 and has provided the
relevant information. The Controller has asked you to calculate the
bond selling price given two different market interest rates using
Excel’s Present Value functions. Use the information included in
the Excel Simulation and the Excel functions described below to
complete the task.
Cell Reference: Allows you to refer to data
from another cell in the worksheet. From the Excel Simulation
below, if in a blank cell, “=B2” was entered,...
Problem #5: You will be making monthly deposits of increasing size into a bank account for...
Problem #5: You will be making monthly deposits of increasing size into a bank account for 5 years. The account will earn continuously compounding interest each month. Every 3 months (i.e. every quarter) the interest rate will increase. The initial deposit will be $227. At the beginning of each month thereafter, another deposit will be made increasing by size $30. The continuously compounded interest rate will be 4.44% per annum for the first quarter, but will then increase by 0.4%...
17. Which formula in B5 will allow you to determine how many years it will take to quadruple your savings at 11% compounded quarterly? a)NPER(B3/B4,0.-BI,B2)/B4 b) NPER(B3/B4,0-B1,B2) c)NPER(B3 B4,0-BI,B2/B4 d)NPER(B3/B4,0-B2,B1) B4 Present Value 2 Future Value 3 Interest Rate 4 Compounding Frequency 5 Number of Years s 3,000 12,000 11% 18. What solution would you get in cell B36? 3s Variable 4 Variable2 35 Variable 3 36 a) 3.333333 b) 1462.96 c) 123.703 d) -2453.85 e) 7606629.6 833 834-835 833/834...
Excel is allowed!
For this lab, we will create a spreadsheet that allows somebody to type in a loan amount, interest rate, and length of the loan in years. The spreadsheet will then calculate the monthly payment required and the actual amount paid on the loan. First, setup your spreadsheet: • In Cell A1, put the label Loan Amount:. The corresponding value would be input in Cell B1. • In Cell A2, put the label Interest Rate:. The corresponding value...
Hello, i want to ask you Inventory cost
=3.6(B1+B2)/2+3.75(B2+B3)/2+3.98(B3+B4)/2+4.28(B4+B5)/2+4.2(B5+B6)/2+3.9(B6+B7)/2,
So, how to compute 3.6, 3.75, 3.98, 4.28, 4.2? And why 3.6X(B1+B2)
and divide by 2? Also, i want to ask the objective function for
this problem why is minimize, not maximize? Thank you for your
help!
The Upton Corporation manufactures heavy-duty air compressors for the home and light industrial markets. Upton is presently trying to plan its production and inventory levels for the next six months. Because of seasonal fluctuations...
If
you bought a stock for $53 dollars and could sell it 16 years later
for three times what you originally paid. What was your return on
owning this stock?
PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A
PICTURE FOR AN EXAMPLE!
Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is...
Q1. Assume you are 25 years old today. If you wish to have saved $500,000 by the time you retire at age 65 (in 40 years), what monthly deposit must you make into your investment account assuming it will earn a fixed-rate return of 6.5%? Place the appropriate values in the proper cells in row 3, given the columns as provided below. Note, where relevant, present value answers should be shown as a negative number. Circle the answer. Provide the...
Ruiz Company issued bonds on January 1 and has provided the
relevant information. The Controller has asked you to calculate the
bond selling price given two different market interest rates using
Excel’s Present Value functions. Use the information included in
the Excel Simulation and the Excel functions described below to
complete the task.
Cell Reference: Allows you to refer to data
from another cell in the worksheet. From the Excel Simulation
below, if in a blank cell, “=B2” was entered,...
Chapter 10 Excel Saved Help Save & Exit Submit Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel's Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. 10 points (8 02:46:24 eBook Print References • Cell Reference: Allows you to refer to data from another...
Ruiz Company issued bonds on January 1 and has provided the
relevant information. The Controller has asked you to calculate the
bond selling price given two different market interest rates using
Excel’s Present Value functions. Use the information included in
the Excel Simulation and the Excel functions described below to
complete the task.
Cell Reference: Allows you to refer to data
from another cell in the worksheet. From the Excel Simulation
below, if in a blank cell, “=B2” was entered,...
Problem #5: You will be making monthly deposits of increasing size into a bank account for 5 years. The account will earn continuously compounding interest each month. Every 3 months (i.e. every quarter) the interest rate will increase. The initial deposit will be $227. At the beginning of each month thereafter, another deposit will be made increasing by size $30. The continuously compounded interest rate will be 4.44% per annum for the first quarter, but will then increase by 0.4%...
Most questions answered within 3 hours.
-
How much must I invest today if I want to withdraw 1/3 of my
original investment...
asked 1 hour ago -
What is meant by a “term premium”?
What can explain such a premium? Is it a...
asked 3 hours ago -
23. Which molecule has only covalent bonds? A. CO2 B. Al2O3 C.
Mg3N2
24. The octet...
asked 3 hours ago -
the
total pressure for a mixture of N2O4 and NO2 is 2.20 atm. If Kp=
7.10...
asked 3 hours ago -
Delaware Corp. prepared a master budget that included $22,385
for direct materials, $28,600 for direct labor,...
asked 3 hours ago -
For pesticide HCB (hexachlorobenzene), its logarithmic partition
coefficient log Kow is 5.6. What would be the...
asked 3 hours ago -
A chemist requires 0.422 mil Na2CO3 for a reaction. How many
grams does this correspond to?
asked 3 hours ago -
If the vapor pressure of carvone is approximately 9.4 torr at 99
°C, approximately how much...
asked 4 hours ago -
A juice bottling company is carrying out a test at 10%
significance that the mean population...
asked 4 hours ago -
What is the reflectivity (in percent) needed to keep water at a
temperature near its freezing...
asked 4 hours ago -
Suppose that the average surface temperature of Earth is 300K.
Assume this is uniform over its...
asked 4 hours ago -
Draw the condensed structural formula for alkenes and alkynes or
the line-angle structural formula for cycloalkenes...
asked 4 hours ago