2. You are considering two ways of financing a spring break vacation. You could put it on your credit card, at 13% APR, compounded monthly, or borrow the money from your parents, who want an interest payment of 6% every six months. Which is the lower rate? (Note: Be careful not to round any intermediate steps less than six decimal places.) The effective annual rate for your credit card is ___%? The effective annual rate borrowing the money from your parents is ___%?(Round to two decimal places.)
EAR=(1+periodic rate)^number of periods-1
The effective annual rate for your credit card is =(1+13%/12)^12-1=13.8032%
The effective annual rate borrowing the money from your parents
is =(1+6%)^2-1=12.3600%
2. You are considering two ways of financing a spring break vacation. You could put it...
You are considering two ways of financing a spring break vacation. You could put it on your credit card, at 18% APR, compounded monthly, or borrow the money from your parents, who want an interest payment of 6% every six months. Which is the lower rate? (Note: Be careful not to round any intermediate steps less than six decimal places) The effective annual rate for your credit card is % (Round to two decimal places.)
you are considering two ways of financing a spring break vacation. You could put it on your credit card, at 16% APR, compounded monthly, or borrow the money from your parents, who want an interest payment of 9% every six months. Which is a lower rate?
A: I need the answers to the question in the black square.
B: I need clarification on how the answers where found (in the blue
cells)
And the most important is (What is the excel formula used to find
the answer in the blue cells?)
.
.
And Its better if you solve it in Excel sheet then upload the
picture here
STCWTE all all & 31 11:53 STC X Problem 5-4 You are considering two ways of financing a...
airements 1 In cell D11, by using cell references, calculate the monthly interest rate of the current credit card (1 pt.). 2 In cell D12, by using cell references, calculate the interest payment on the current credit card (1 pt). Note: The output of the expression or function you typed in this cell is expected as a positive number. 3 In cell D13, by using cell references, calculate the monthly interest rate of the new credit card (1 pt.) 4...
You have credit card debt of $30,000 that has an APR (monthly compounding) of 18%. Each month you pay the minimum monthly payment. You are required to pay only the outstanding interest. You have received an offer in the mail for an otherwise identical credit card with an APR of 9%. After considering all your alternatives, you decide to switch cards, roll over the outstanding balance on the old card into the new card, and borrow additional money as well....
(10 points) You ran a little short on your vacation. You have two options: • Option 1: Put $1,000 on your credit card. The annual interest rate on the credit card is 12% compounded monthly. Option 2: Take out a $1,000 short-term loan from CIBC with annual percentage rate of 12.4% compounded quarterly. a) Which option would you choose? Why? b) Let's say you conclude that you better off using your credit card (Option 1). You can only afford to...
3. You have found three investment choices for a one-year deposit:10.0 % APR compounded monthly, 10.0% APR compounded annually, and 9.0% APR compounded daily. Compute the EAR for each investment choice. (Assume that there are 365 days in the year.) (Note: Be careful not to round any intermediate steps less than six decimal places.) 4. Suppose Capital One is advertising a 60-month, 5.99 %APR motorcycle loan. If you need to borrow$8,000to purchase your dream Harley-Davidson, what will be your monthly...
QUESTION 5 Suppose you want to buy a house that costs $750,000. You are required to put 10% down, which means the amount to be borrowed is 90% of the price of the house. If you want a 30 year mortgage, and the borrowing rate is 5.6% APR compounded monthly, what would be your monthly payment? (Answer to the nearest penny) 5 points QUESTION 6 Suppose you want to buy a car that costs $17,000. If the dealer is...
Effective Annual Rate (EAR) problems. Remember, percentages must be to 2 decimal places.ch 5.25%: a. Abe has a credit card that has an annual percentage rate (APR) of 21% Interest is compounded monthly Calculate the EAR. b. From question "*". Calculate the EAR if interest is compounded weekly (assume 52 weeks.) c. From question "a". Calculate the EAR if interest is compounded continuously. d Barb has a loan which has an APR of 6%. Interest is compounded semi-annually. Calculate the...
You have credit card debt of $37,500 that has an APR (monthly compounding) of 16%. Each month you pay the minimum monthly payment only. You are required to pay only the outstanding interest. You have received an offer in the mail for an otherwise identical credit card with an APR of 11%. After considering all your alternatives, you decide to switch cards, roll over the outstanding balance on the old card into the new card, and borrow additional money as...