Please show how to solve this in Excel using Excel formulas and please show the spreadsheet so I can understand better. Suppose Cindy borrows $300,000 at 4% for 30 years, monthly payments. The APR on the loan is 4.25%. What amount of points were charged if there was $5,000 origination cost?

Please show how to solve this in Excel using Excel formulas and please show the spreadsheet so I can understand better. Suppose Cindy borrows $300,000 at 4% for 30 years, monthly payments. The APR on the loan is 4.25%. What amount of points were charged if there was $5,000 origination cost?

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter19: Lease And Intermediate-term Financing

Section: Chapter Questions

Problem 19P

See similar textbooks

Related questions

Q: Prepare an amortization schedule for a three-year loan of $63,000. The interest rate is 10 percent…

A: The problem case wants to create the loan amortization schedule for the loan that is to be repaid in…

Q: Long lines of patients wait for CAT scanning service in a hospital. Patients arrive for scans at a…

A: The corrected answers are:1. Probability that the system is empty: 0.5382. Probability that a…

Q: In historical data, we see that investments with the highest average annual returns also tend to…

A: The question is based on the fundamental concept of the risk-return trade-off in the field of…

Q: ABC's preferred stock has a par value of $100, a dividends rate of 5%, and a market price of $155;…

A: In case of paymentThe first payment is done to the debt holders of the company.So when company pays…

Q: UGABCD Country Greece Cash Return 2.0 5-year Excess 10-year Excess Bond Return (%) Bond Return (%)…

A: Expected Return of Portfolio: It is the value which is derived by multiplying the expected return of…

Q: Required information Section Break (8-11) [The following information applies to the questions…

A: Expected return of stock fund (S)16%Expected return of bond fund (B)10%Risk-free rate…

Q: You are looking to purchase a Tesla Model X sport utility vehicle. The price of the vehicle is $94,…

A: To find the balloon payment for the Tesla Model X SUV:- Calculate the monthly interest rate using…

Q: For the cash flows shown, determine: (a) the number of possible i* values (b) the i* value displayed…

A: A time series of revenue and costs is provided. Use them to find the time series of net cash flow.…

Q: Logan had seamless rain gutters installed around her home at a cost of $1,500. She financed the…

A: Here,Cost of Home (PV) is $1,500Interest Rate (r) is 2.5%Time Period (t) is 18 monthsCompounding…

Q: Which of the following statements is CORRECT? a. Portfolio diversification reduces the variability…

A: The objective of the question is to identify the correct statement among the given options related…

Q: Suppose that the index model for stocks A and B is estimated from excess returns with the following…

A: ParticularsStock AStock BBeta1.201.50R-square0.250.15σM16%Weight0.700.30

Q: If employee-investors are unsophisticated and unlikely to be materially influenced by educational…

A: Employee-investors refers to employees who are also shareholders in their company through their…

Q: JPMorgan Chase & Co., commonly known as JPMorgan, boasts one of the global financial industry's…

A: The post provides a comprehensive overview of JPMorgan Chase & Co.'s organizational structure.…

Q: Calculate cash flow from investing activities. Year 1 Year 2 Interest paid to debtholders 72.0 77.0…

A: Cash flows from investing activitiesCash flows from investing activities refer to the cash inflows…

Q: Scott Corp. is a manufacturing firm. Scott Corp.'s current value of operations, including debt and…

A: Here, Face Value of Outstanding Debt (Strike Price) $ 14,000,000.00Value of Firm (Stock Price) $…

Q: Amanda Rice has just arranged to purchase a $540,000 vacation home in the Bahamas with a 30 percent…

A: Balloon payment refers to a payment of huge amount that is paid at end of the loan at one time which…

Q: A project has the following cash flows: Year Cash Flows 0 01234 2 -$ 10,900 4,630 6,640 4 4,160…

A: The MIRR is a rate that takes into consideration reinvesting positive cash flows at the company's…

Q: Inputs ettlement Date Maturity Date oupon Rate oupons per Year Tagliaferro Incorporated 10 Year Bond…

A: Duration of bond shows the weighted period required to recover all cash flows from the bond and that…

Q: This asset is similar across other asset replacement questions: An asset has a first cost of…

A: Present value=future value/(1+r)^n

Q: How much will $3,000 invested at the end of each year grow to in 4 years, assuming an interest rate…

A: An annuity is a series of payments made at equal intervals.The future value of an annuity is the…

Q: Returns for the Cabell's Company over the last 3 years are shown below. What's the standard…

A: Standard deviation quantifies the volatility in a stock's returns relative to its average return,…

Q: DFB, Inc. expects earnings next year of $5.00 per share, and it plans to pay a $3.00 dividend to…

A: To apply the constant dividend growth model, 2 requirements have to be fulfilled:(1) The growth rate…

Q: If the current rate of interest is 10% and interest is compounded semiannually, what is the present…

A: Compound = Semiannually = 2Interest Rate = r = 10 / 2 = 5%Future Value = fv = $10,000Time = t = 7 *…

Q: 10. Fred creates a loan agency. They will finance elite vehicles to UBER drivers. Fred explains his…

A: In a world where transportation needs are rapidly evolving, Fred saw an opportunity to bridge the…

Q: Jane won the $70 million lottery. She is to receive $1 million a year for the next 50 years…

A: The present value of any cash flow/series of cash flows can be determined by following a process…

Q: Use graphical approximation techniques or an equation solver to approximate the desired interest…

A: Annual Payment = p = $1000Time = t = 5 YearsFuture Value of Payment = fv = $5700.46

Q: A company borrows $4 to finance a project. It has two choices when beginning the project. The first…

A: Expected value is the probability-weighted value of payoffs at different scenarios. This helps in…

Q: Underlying Microsoft (MSFT) Price: 295.71 Expiration Strike Call Put 1-Oct-2021 290 9.43 3.63…

A: In the context of option trading, the payoff and profit or loss from call and put options are…

Q: How much would you have to invest today to receive: Use Appendix B and Appendix D. (Round "PV…

A: Present value is the equivalent value of money today based on the time value of money that is going…

Q: An annuity providing a rate of return of 4.8% compounded monthly was purchased for $45,200. The…

Q: Amanda borrowed $6,095 from her best friend, 11 months later, Amanda repaid her $7,005. Calculate…

A: The objective of the question is to calculate the effective annual interest rate for a loan that…

Q: YYou expect your retirement fund to be able to afford $40,000 a year, adjusted for 3% annual growth…

A: Payment = p = $40,000Growth Rate = g = 3%Time = t = 20Rate of Return = r = 10%

Q: Cumulative preferred stock O requires dividends in arrears to be paid before the firm can pay…

A: Cumulative preferred stocks Answer : requires dividends in arrears to be paid before the firm can…

Q: Using the expectations hypothesis theory for the term structure of interest rates, determine the…

A: Expected return, according to expectation hypothesis theory, is the return expected by a bond…

Q: Microsoft Corp. just paid a dividend of $2.49 per share. The company said that it will increase the…

A: Current Dividend = d0 = $2.49Growth rate for year 1 = g1 = 25%Growth rate for year 2 = g2 =…

Q: Kwon Jewelers is evaluating a 1-year project that would involve an initial investment in equipment…

A: To calculate the net present value (NPV) of the project when Kwon Jewelers borrows $32,000 to pay…

Q: A proposed cost-saving device has an installed cost of $730,000. The device will be used in a…

A: NPV is also known as Net Present Value.. It is a capital budgeting technique which helps in decision…

Q: Freedman Flowers' stock has a 50% chance of producing a 25% return, a 30% chance of producing a 10%…

A: The objective of the question is to calculate the expected rate of return for Freedman Flowers'…

Q: onsider the accompanying balance sheet for a anadian chartered bank. an additional $1,000,000 is…

A: Deposit requirements, also known as reserve requirements, refer to the regulations imposed on banks…

Q: Calculate stock and bond valuations for PepsiCo. Specifically, the following critical elements…

A: All the formulae required for calculations are already provided in the excel images. We will provide…

Q: Founders of a firm put up 140 million at time 1 to be withdrawn completely at time 2 by selling the…

A: To calculate the market values of the firm at each period, we need to discount the future cash…

Q: Krell Industries has a share price of $22.12 today. If Krell is expected to pay a dividend of $0.94…

A: Share price today (P0) = $22.12Next year dividend (D1) = $0.94Next year share price (P1) =…

Q: Rare Agri-Products Ltd. is considering a new project with a projected life of seven (7) years. The…

A: To compute the earnings after taxes for years 1 through 7, we need to follow these steps:Calculate…

Q: Please show exactly how to solve this in excel and all steps in excel please. Five years ago,…

A: Charles initially secured a $400,000 mortgage at a 5% interest rate, leading to a monthly payment of…

Q: You have just purchased a new warehouse. To finance the purchase, you've arranged for a 25-year…

A: APR is the Annual Percentage Rate refers to the percentage of financial charges and fees charged on…

Q: Gina Mendonca has marginal tax rate of 26%. She earns $82,434 every year and contributed $6,905 to…

A: The objective of the question is to calculate the amount of tax savings for Gina Mendonca based on…

Q: Rust Industrial Systems Company is trying to decide between two different conveyor belt systems.…

A: Net Present Value is used to evaluate the investment and financing decisions that involve cash flows…

Q: Suppose that during the coming year, the risk free rate, rRF, is expected to remain the same, while…

A: The objective of the question is to understand the impact of a decrease in the market risk premium…

Q: Cumulative preferred stock O requires dividends in arrears to be paid before the firm can pay…

A: The preferred stock is the type of stocks where the repayment of preference dividend and principal…

Q: beatrice invest 1350 $ in an account that pays 4 percent simple interest how much more could she…

A: Simple interest future balance and compound interest future balance are calculated using the…

Question

Please show how to solve this in Excel using Excel formulas and please show the spreadsheet so I can understand better.

Suppose Cindy borrows $300,000 at 4% for 30 years, monthly payments. The APR on the loan is 4.25%. What amount of points were charged if there was $5,000 origination cost?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Define mortgage.

VIEW

Step 2: Compute the points charged.

VIEW

Solution

VIEW

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the debt in 3 annual installments at the end of each year, which would include interest at 14%. Draw a time line for the problem. Indicate what table to use. Look up the table value and place it in a brief formula. Solve.
Please show how to solve this in Excel using Excel formulas and please show the spreadsheet so I can understand better. Suppose Tommy borrows $500,000 at 4% for 15 years and monthly payments. The annual percentage rate (APR) on the loan is 4.5%. What amount of discount points was charged if there was $4,500 origination cost?
Please show how to solve this in excel and please show the spreadsheet and formulas. Suppose that you have the following two loans with monthly payments in the table attached as Choice 1 and Choice 2. Assuming that there is no origination cost with the loans. If Robin pays off the loan in 15 years(180 months), what is the incremental cost of the $10,000 for loan 1 over loan 2?
Suppose Marty borrows $300,000 at 4% for 30 years, monthly payments. The APR on the loan is 4.25%. What amount of points were charged if there was $5,000 origination cost? Please solve using excel and excel formulas
Please show me how to solve this in excel using an excel spreadsheet and please show the excel formulas! Thank You! A house price of $100,000 can be financed with two loans below with monthly payments. The total origination cost associated with these two loans in the table attached is $3000. Alternatively, the borrower can borrow one loan in the amount of $90,000 with monthly payments and origination cost of $2,000. What should the interest rate be on the loan of $90,000 so that the borrower will be indifferent between these two choices?
Using the information provided please show all work and formulas in excel ! Suppose that you have two loan choices with monthly payments (a) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for the entire term and there are no origination costs for the two loans? (b) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for only 6 years (72 months) and there are no origination costs for the two loans?
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.)
You lend a friend $10,000, which your friend will repay in 5 equal annual end-of-year payments of $3,000, with the first payment to be received 1 year from now. What rate of return does your loan receive? I need to be able to use excel and manually calculate as well.
Mr. Nina borrows $425,000 from the bank at 3.5% per year interest over a 30-year period. He can make a monthly month-end payment of $1,400 and would like to make a balloon payment at the end of the 30-year period. What would be the size of the balloon payment? $218,058 $323,069 $433,197 $548,512 Please show how to work this out in Excel if possible?
You go to the loan fund of the company where you work and find that they have an emergency fund whose regulations establish that the credits will be paid in monthly installments for 12 months, and that the installments 3,6,9 and 12 will be double the others. Likewise, the interest is 3 % per month. The amount that they will lend depends on the installment. a) If you are loaned $500,000, what will the normal payments be? b) If your regular payments are $10,000, what would be the value of the loan?
Please show how to solve this using excel and please show all formulas in the spreadsheet please!! Steven decides to buy a house with price of $500,000, Steven puts 20% down payment and considers a 15-year fixed rate mortgage to pay the remaining balance. The lender offers him three choices of the mortgage with monthly payments shown in the table as a., b., and c. Assume that the origination cost is $8,000. A. If the loan will be outstanding for 15 years, what is the effective cost for each choice? Which choice is most ideal? explain? B. Which mortgage choices are not properly priced? explain?
While Jack was a student at the University of Georgia she borrowed $12,000in student loans at an annual interest rate of 9%. If Jack repays $1,500 per year then how long (to the nearest year) will it take him to repay the loan? Use an excel to understand the calculation