Q. Jayden borrows $10500 from his grandmother for 4 years. Jayden’s grandmother gives Jayden a simple annual interest loan at 4.5% interest. How much will Jayden need to repay grandma in interest? How much in total will Jayden pay? Answer it only using Excel spreadsheet showing all formula. I will really upvote. Thanks Please don't give me answer without using Excel
Q: 4. Suppose a $1000 EOY loan payment was made today for money that was borrowed five years ago. If…
A: Loan payment is $1,000 made today Time period is five years Inflation rate is 2% To Find: Value of…
Q: Sherry has a goal of retiring with $371,060 by making weekly deposits into an investment account…
A: When payments are made in equal intervals of equal amounts, it is called annuity. The total amount…
Q: She arranged to receive $45,000 the first year. Because of inflation each year she will get $580…
A: A regular payment received by retired people is called pension. Inflation is the increase in general…
Q: he bond matures in 10 years, at which time it will pay 1000. If the coupon rate is 7% and discount…
A: The bond price is calculated as present value of cash flows from bond
Q: Which of the following statements about Floating-Rate Debt is NOT true? A) Floating-rate debt has…
A: A floating rate note is a debt instrument that allows companies to keep the interest rate variable…
Q: Not use excel Q)You take out a home loan for $250,000, with an annual interest rate of 6% for 30…
A: Solution:- When a loan is taken, it is to be repaid as a lump sum payment or in installments. When…
Q: NITIAL COST R100 000 R110 000 EXPECTED ECONOMIC LIFE 5 YEARS 5 YEARS EXPECTED DISPOSAL/RESIDUAL…
A: Payback period can be defined as the time taken to recover the initial capital invested in a…
Q: The risk-free rate is 3%, the market risk premium (MRP) is 8%, and the Beta of Lotsa Dough common…
A: Risk free rate = 3% Market risk premium = 8% Beta = 0.90
Q: 10. A corporation has decided to use borrowed capital to finance a portion of an equipment purchase.…
A: A loan amortization schedule is a schedule showing the Opening balance, closing balance and…
Q: a. When we start to think about who actually owns U.S. debt, does $27.7 trillion seem like the…
A: Public debt are the obligations of the government. It is the total amount that has been borrowed by…
Q: You would like to purchase a car that costs $47000 at 7% APR for 3 years. What is your monthly…
A: Cost (PV) = $47000 Interest rate = 7% Monthly interest rate (r) = 7%/12 = 0.583333333333333% Period…
Q: In 2000, the value of the Consumer Price Index was 171.20 and the price of gasoline (per gallon) was…
A: The rate at which the value of a country is decreasing and rates of goods and services are…
Q: 4. IBM stock is currently trading at $100 per share. An investor purchases one Call option contract…
A: A call option provides the holder the right but not the obligation, to buy a certain security at a…
Q: MG Golf has decided to sell a new line of golf clubs. The clubs will sell for $815 per set, with a…
A: Here, Tax Rate is 25% Cost of Capital is 10% Fixed Cost is $9.45 million Note: R&D Cost and…
Q: internal rate of return (IRR): Group of answer choices will always lead to the same decision as…
A: IRR is a method used for investment appraisal. It is the rate of return at which the present value…
Q: Suppose a firm uses the WACC as the single hurdle rate in determining the value of capital budgeting…
A: The overall cost of capital, also known as the Weighted average cost of capital (WACC), is the…
Q: $11,000 is to be paid at the end of each year in a legal settlement. The payments end after 9 years.…
A:
Q: 15% n=7 Initial Cost (A)100 (B)60 (C)80 Uniform Annual Benefit (A)26 (B)15 (C)17 a)…
A: Budget is the process by which a firm assesses truly massive projects or investments.A new plant's…
Q: Management is considering buying a pump that costs $20,000 and could save them $7,500 per year over…
A: Solution:- The investment should be made or not will depend on the Net Present Value (NPV). If NPV…
Q: How does an increase in price of share of acquiring company affect the value to the target in…
A: The increase in price of the share of acquiring company and its effect on the value of stock of…
Q: 6b. An initial $2000 investment is made that returns profits of $1000 and 1500 in the first and…
A: Here, Initial Investment is $2,000 Profit in Year 1 is $1,000 Profit in Year 2 is $1,500 Inflation…
Q: can you explain what is "GME, Melvin Capital and the “Gamma Squeeze”
A: GME, Melvin Capital and the ‘Gamma Squeeze’ have an important relevance in the world of finance.…
Q: Consider the following cash flows. The interest rate is 10%. What is the duration (hint: you need…
A: Duration measures the sensitivity of an asset's price to changes in interest rates. Duration can be…
Q: 4 QUESTION 9 A wealthy donor has given $400,000 to a university and specifies that it is to be used…
A: An individual usually saves for the future through depositing the smaller amount of the funds from…
Q: You invested in the no-load Best Mutual Fund one year ago by purchasing 900 shares of the fund at…
A: Purchase price (NAV0) = $19.44 Dividend (D) = $1.88 Capital gain (C) = $2.12 NAV at the end of year…
Q: can you explain this pic by words Net Present Value Sales Net cash flow Initial investment -72000000…
A: Data given: Year Initial investment Operating cost Sales Net Cash Flow -72000000 0 0 0 2024…
Q: rom the following facts, for straight-line depreciation, what is: Given: Cost - $ 35,000…
A: Solution: Depreciation means the cost of wear and tear of the property, plant and equipment of firm.…
Q: Identify three financial signs that are considered red flags. Briefly describe in one sentence for…
A: A red flag is a warning or a threat that tells the company that there is a potential threat to the…
Q: Question 1: Darby is running a flower stand, and is selling a single bouquet for $31.50. Her…
A: Solution: Fixed Cost is the fixed charges incurred by a firm in its operations. We have, Break even…
Q: A) What is the formula for calculating Beta for a portfolio with three mutual funds?
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Your employer offers a 401(k) plan with a 17% match, and you set a goal of retiring in 35 years with…
A: Given: Value today = $1.1 million or $1100000 Inflation rate = 1.5% Annual rate = 1.2% Number of…
Q: You have reached an agreement with an auto dealer regarding a new car. She has offered you a…
A: A loan is an agreement where an amount is forwarded in exchange for interest being paid as well…
Q: ana has to pay RM1,200 every month for 360 months to settle a housing loan at 4% compounded…
A: Here we will use the concept of time value of money. As per the concept of time value of money the…
Q: Describe the following stakeholders’ objectives and what a financial manager needs to be mindful of…
A: A stakeholder is someone who has a vested interest in a company and has the ability to affect or be…
Q: Sketch the NPV profile for projects A & B. Determine the crossover point for these projects’ NPV…
A: NPV refers to the net present value. It is the sum of present values of all cash flows occuring in…
Q: Last year you bought 100 shares of NC Corp. common stock for P53 per share. During the year you…
A: The rate of return is simply calculated as capital gain yield plus dividend yield
Q: Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an…
A: The ideal order ize for a company is called economic order quantity. It minimizes order cost and…
Q: An amount of $15,000 is accumulated at a simple interest rate of 8% per annum or at a compound…
A: Present value = $15,000 Simple interest rate = 8% Compound effective interest rate = 7.5%
Q: 1. A firm has the following capital structure: thousands € Liabilities and equity thousands € Assets…
A: WACC = kd*D/A+ke*1-D/Awhere, kd = Cost of debt or debt interest rateke = Cost of equityD/A =…
Q: You are going to invest P20,000 in a portfolio consisting ofassets X, Y, and Z, as follows:…
A: An expected return is defined as the profit or loss, which an investor used to anticipate on…
Q: You are considering buying below corporate bonds for income generation: Tesla 4% per year…
A: We need to calculate bond price using PV function in excel. The formula is =-PV(RATE,NPER,PMT,FV)
Q: Adding insurance-linked securities to a portfolio can increase an investor's return without…
A: Insurance linked securities are financial instruments whose value is primarily based on insurance…
Q: What does it mean for markets to be efficient? What are the differences in the degree of efficiency,…
A: The markets are considered to be efficient if the information related to various aspects that create…
Q: Planet has just announced an ordinary dividend per share of 20p. The past four years’ dividends per…
A: Share is a company’s securities which are issued to raise the funds. Value of share fluctuates due…
Q: A Large pizza at Brismarcks’s pizzeria cost$6.80 plus $0.90 for each topping.The cost of a large…
A: Solution:- In order to find out the number of toppings, the total cost of pizza from both the pizza…
Q: If a company already owns the land on which it plans to build a factory, the land should be treated…
A: If a company already owns the land on which it plans to build a factory, the land should be treated…
Q: If one U.S. dollar buys 0.6 euro, hoe many dollars can you purchase for one euro?
A: Solution:- Exchange rate means when one currency is denominated in another currency’s rate.
Q: Using the same information, what is the amount of the S Corporation premium if the cash flow for the…
A: Cash flow is basically the inflow and outflow of money, where we deal with operating activities,…
Q: What would be your realized yield to maturity if you sold the bond after 10 years?
A: Realized yield to maturity (YTM) refers to the yield or total return earned or realized by the…
Q: Scooter wishes to sell a bond that has a face value of $1,075. The bond bears an interest rate of…
A: Face value (FV) = $1075 Coupon rate (C) = 9.85% Coupon payments per year (Q) = 4 Yield rate =…
Q. Jayden borrows $10500 from his grandmother for 4 years. Jayden’s grandmother gives Jayden a simple annual interest loan at 4.5% interest. How much will Jayden need to repay grandma in interest? How much in total will Jayden pay?
Answer it only using Excel spreadsheet showing all formula.
I will really upvote. Thanks
Please don't give me answer without using Excel
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- Use the given spreadsheet formulas for each question below. Write down your calculations and/or what you type into excel to show your work, as well as the final answer. Answer each question with a complete sentence response. No credit will be given if the Excel/sheets syntax is not provided. Round your answer to the nearest cent. Q. Jayden borrows $10500 from his grandmother for 4 years. Jayden’s grandmother gives Jayden a simple annual interest loan at 4.5% interest. How much will Jayden need to repay grandma in interest? How much in total will Jayden pay?1. Rayleene is getting a loan to buy a used car from a seller on Kijiji. The price of the car is $9200.00. She has a down payment of $500.00 and is able to negotiate an interest rate of 4.5% from her bank. Rayleene is trying to decide whether to get her loan for 3 or 4 years. a. Use an online personal loan calculator to fill in the following table to help her decide: Amount of Principal Interest Rate Length of Loan 3 year loan 4 year loan Monthly Payment Total Payments (Monthly Payment x # of months) Total Cost of the Loan (Total Payments – Principal) b. Should Rayleene take her car loan out for 3 or 4 years? Why?6. Ms. Lanz takes out a $9,000 loan to buy a used car for her daughter. She gets a 4-year loan at 8.75% interest. Her payments will be $222.90 a month. What is the total repayment of the loan? $9891.60 G $16,992.00 H $10,699.20 Not Here
- Alisha is buying a car for $26,000. She has $1,800 for a down payment She plans to borrow the remainder at a 3.2% annual rate for 5 years. How much are her monthly car payments? $442.87 $437.00 $469.50 O$475.47 $425.38 Previous Page Next Page Page 9 of 30 Submit Quiz O of 30 questions savedSherry Smart is buying a $350,000 home and will pay the mortgage monthly for 30 years. She has a good credit score and has qualified for a 5.125% loan interest. How much will she be paying monthly for the home? Question 2Answer a. $1,318.69 b. $2,013.67 c. $975.88 d. $1,572.72Problem 1 Michelle borrows $7, 200 from her father to buy a used car. She repays him after9 months, at an annual simple interest rate of 6.2%. Find the total amount she repays. PlEASE GIVE FULL SOLUTION
- enny takes out a new car loan for $41,000 at 5% annual interest rate for 5 years. a. What is Jenny’s monthly payment? Two years later, Jenny has already made 24 monthly payments (of amount calculated in a.) and has 36 remaining payments. What is the remaining principal on the loan? Solve using two methods. b. Solve by calculating the Present Worth of the remaining 36 payments. c. Solve using Excel Spreadsheet function CUMPRINC as discussed on page 165 of text. (note: you should get same answer on b. and c.)Allan borrowed $5600 from his father to buy a car. He repaid him after 6 months with interest of 9% per year. Find the total amount he repaid. Select one: a.$5810.00 b.$6104.00 c.$5852.00 d.$252.00You want to borrow $500 from your cousin Vinny. He gives you the special family rate of 1% per week. What are the APR and EAR on this loan? Multiple Choice 52%; 52% 52%; 60.10% 67.77%; 52% 52%; 67.77% 60.10%; 52% Show me all the calculation steps
- Sarah graduated from college with $29000 in student loan debt. The annual rate on her loans is 6 percent simple interest, and she will make monthly payments for 10 years. What is the remaining balance on her loan after five years, or 60 months? (Hint: Use the amortization function on your financial calculator or Excel Worksheet 5.6.) O $14500 O $16654 O $9682 $193182. Remi deposits $2,000 into a savings account at her bank. If the interest rate is 3.25 percent, how much money will she have in her account after 5 years? 7. You are Co introductory rate months and the rate be entered into a drawin commercial. You pay $50 a you switch? Use the smart dec mathematically and include an emO CONSUMER MATHEMATICS Finding the monthly payment, total payment, and interest for a... When Laura bought her house, she got her mortgage through a bank. The mortgage was a personal, amortized loan for $99,500, at an interest rate of 3.75%, with monthly payments for a term of 40 years. For each part, do not round any intermediate computations and round your final answers to the nearest cent. If necessary, refer to the list of financial formulas. (a) Find Laura's monthly payment. (b) If Laura pays the monthly payment each month for the full term, find her total amount to repay the loan. $0 (c) If Laura pays the monthly payment each month for the full term, find the total amount of interest she will pay. $0 X Monthly Payment Formula M= P r 12 r 1- ( 1 + 12 ) - 12t