Question

Work problem 1a and 1b with your calculator, using the algebra
equations if possible (show work), and using the finance = function
available in your spreadsheet **Show what Algebraic Formula
you use. Submit a screenshot of this sheet filled out with the
algebraic calculations, and submit your excel
spreadsheet.**

- a Suppose your Uncle died and provided in his trust that you will receive $5,000 at the end of each year for the next 10 years. Assume you can earn 8.5% per year. How much is this worth to you now?

Show work: Spreadsheet Answer________

- b Suppose you would like to buy a $12,000 atv with $2,000 down. The company will finance the remaining $10,000 at 4.5% per year with monthly payments over the next 5 years. What will your monthly payment be?

Show work: Spreadsheet Answer________

Answer #1

Work problem 2a and 2b with your calculator, using the algebra
equations if possible (show work), and using the finance = function
available in your spreadsheet Show what Algebraic Formula
you use. Submit a screenshot of this sheet filled out with the
algebraic calculations, and submit your excel
spreadsheet.
2 a.
Suppose you owe a credit card company $9,500 and you can afford to
pay $270 per month. The card charges you 16% per year. How long
will it take...

1a. Convert 101011101011011101 (base 2) to hexadecimal. Show
your work.
1b. Convert 67 (base 10) to 8-bit binary using signed magnitude.
Show your work.
1c. Convert 69 (base 10) to 8-bit binary using one’s complement.
Show your work.
1d. Convert 70 (base 10) to 8-bit binary using two’s complement.
Show your work.

Solve the system of equations or minimize using matrices. Show
all work
1a-1b+2c+1d=2
2a-3b-3c-1d=2
-1a+2b+1c+3d=3
-1a+3b+8c+6d=8

PLEASE PLEASE SHOW YOUR WORK
1a. Solve the equation: y = 3x2 -2x - 5
1b. Now use f(x) = x3 + 2x2 -5x - 6 to
list all of the potential rational zeros of this function AND find
the real zeros of f algebraically (show synthetic division at least
once) and use the to factor f.

Show work through excel using formulas: but please actually show
each step you use to do it on excel!
1. Assume you have taken out a balloon mortgage loan for
$2,500,000 to finance the purchase of a commercial property. The
loan has a term of 5 years, but amortizes over 25 years. Calculate
the balloon payment at maturity (Year 5) if the interest rate on
this loan is 4.5%.
A. $5,637.99 B. $13, 895.82 C. $2,196,447.59 D.
$2,495,479.19

Please show your steps for each part of the
problem, and if a calculator was used, list the
button combination pressed in order to arrive at
your answer!
a. Jack and Jill are twins and at 20 years of
age they both opened separate investment accounts with an on online
broker. Jack started investing $50 a month starting from today.
Jill will save $55 a month starting at the end of the month. if
this investment account gives them 8%...

1A (13 pts). Suppose that a coupon bond has a face value of
$1,000, a maturity of 3 years, and the holders of this bond receive
a number of semi-annual interest payments and receives $1030 when
the bond matures. If you are told that the yield to maturity (the
interest rate on a comparable investment) for this bond is 5%,
calculate the number of payments received by the holders of this
bond, the present value of each of these payments,...

1a.
Determine your monthly payment on a 20-year $130,000 mortgage
loan at 6 7/8% interest.
a
$998.16
b
$990.79
c
$998.55
d
$933.93
1b.
You want to start a landscape business and estimate it will take
$12,500 to get started. You currently have $1,500 and can deposit
an additional $200 at the end of each month. If your savings plan
will earn 4.5% compounded monthly, in how many months can you start
your business?
a
23.80 months
b
48.85 months...

Show all your work (use of formula, etc.) in solving the
problems. You still need to show your work even if you use the
financial calculator to get the answers.
2. You are planning to save for retirement over the next 40
years. To do this, you will invest $900 per month in a stock
account and $500 per month in a bond account. The return of the
stock account is expected to be 8 percent per year (compounded...

How do you do this problem using a Ti-84 calculator "apps",
"finance", "TVM Solver."
---------------------------------------------------------------------------------------------
Part A.)
I am starting a retirement savings program. I expect to need
$2,000,000 in 40 years I begin with a deposit of $650.00 and then
deposit $450.00 per month at an interest rate of 0.500% per month I
also have a trust fund that will add $20,000 to the fund at the end
of the 7th year What will my monthly deposit need to...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 9 minutes ago

asked 9 minutes ago

asked 13 minutes ago

asked 19 minutes ago

asked 30 minutes ago

asked 31 minutes ago

asked 31 minutes ago

asked 47 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago