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
Q: AFW Industries has 180 million shares outstanding and expects earnings at the end of this year of…
A: Expected Earnings =$735millionOustanding shares =180millionPayout ratio =56%Growth rate =8.9%Cost of…
Q: A 99-unit apartment building that was acquired for $2.7 million generates a 7.5% before tax annual…
A: Debt service coverage ratio refers to the ratio which is used for measuring the availability of the…
Q: During the last accounting period, Sheridan Corporation sold 92000 units at $45 each. The variable…
A: Degree of operating leverage is a financial measure that helps to determine the impact on the net…
Q: Consider the following sets of investment projects n(years) A(S) B($) C($) D($) 0 -3,500 -5,800…
A: Equivalent Annual Worth (EAW) translates the net present value of an investment into an annual…
Q: The Faulk Corp. has a 7 percent coupon bond outstanding. The Yoo Company has an 11 percent bond…
A: The price of the bond changes with the change in interest rate and change in the coupon rate. If the…
Q: If the number of workers in auto assembly in Canada declined by 32% from its peak at the end of 1999…
A: Compound annual rate of return is a measure of an investment's annual growth rate over multiple…
Q: The standard deviation of Nvidia's stock return is 14.004%. For AMD it is 17.035% and for the market…
A: Plug the values into the…
Q: (Related to Checkpoint 11.1) (Net present value calculation) Dowling Sportswear is considering…
A: Net present value (NPV) of an investment refers to the variance between the initial investment or…
Q: Cori's Dog House is considering the installation of a new computerized pressure cooker for hot dogs.…
A: The net present value is the difference between the PV of all cash flows and the initial…
Q: A 20-year maturity, 6.5% coupon bond paying coupons semiannually is callable in five years at a call…
A: Yield to Maturity : Yield to Maturity refers to the rate of return of a bond. It is the percentage…
Q: Dog Up! Franks is looking at a new sausage system with an installed cost of $465,000. This cost will…
A: Initial cost = $465,000Working capital = $27,000Salvage value = $61,000Savings = $143,000Tax rate =…
Q: Shannara Manufacturing writes 30 checks a day for an average amount of $497 each that generally…
A: The term "cheque collection float" describes the little delay that occurs between the time one…
Q: Expected Portfolio Return Beta Risk-free Market A 5% 10.6 8.6 0 1.0 1.6 Required: a. Calculate the…
A: The alpha of a portfolio refers to the measure of excess return that the portfolio provides over its…
Q: Rare Agri-Products Ltd. is considering a new project with a projectedlife of seven (7) years. The…
A: The answer is in the explanation.Explanation:Part 1: Computing the Appropriate Discount RateThe…
Q: A washer-dryer combination can be purchased from a department store by making monthly credit card…
A: For the calculation of purchase price, we need to use the following formula for annuity due where…
Q: Compute the CAPM alpha of ABC. % Compute the volatility of the idiosyncratic component of return of…
A: The alpha indicates how well an investment performs in relation to expectations. An investment…
Q: Which of the following statements is CORRECT? a. The slope of the Security Market Line is beta.…
A: The objective of the question is to identify the correct statement among the given options related…
Q: Washington Mutual was a US Bank which went bankrupt at the end of 2008 due to a number of risk…
A: See the answer in the explanation field.Explanation:Answer information:Step 1:A. Credit Risk from…
Q: Assume Evco, Inc. has a current stock price of $50.29 and will pay a $2.10 dividend in one year; its…
A: The constant growth model is a model for finding out the price of share on the basis of future…
Q: Copper Corp. has an outstanding bond issue that is currently selling for $1,073.95. The yield to…
A: The current yield is a crucial metric for investors to assess the income potential of a bond…
Q: of gold is $6 per ounce and the price of gold is expected to increase at a rate of 5 percent per…
A:
Q: What is the present worth of a 6-year annuity paying P3,000.00 starting at the end of five years,…
A: Compound = Semiannually = 2Payment = p = P3000Interest Rate = r = 8 / 2 = 4%
Q: Consider two mutually exclusive projects A and B: Cash Flows (dollars) Project A B Co -35,500…
A: IRR is the break even rate at which NPV is zero and present value of cash flow is equal to initial…
Q: Which of the following phrases might be useful in writing the purpose statement for your formal…
A: The correct answers are:The report determinesThe research explainsThis report justifiesWe analyze…
Q: 1. You are evaluating investing in a private equity fund and estimate that it will yield the…
A: The objective of this question is to calculate the Internal Rate of Return (IRR) for the given cash…
Q: On a 15-year, $200K mortgage at 4% APR, how much interest will you pay in ONLY the second year if…
A:
Q: Consider two mutually exclusive projects A and B: Cash Flows (dollars) Project A Co -31,000 B…
A: Cash flow (Dollars)ProjectC0C1C2NPV@12%A-$31,000$21,800$21,800$5,843B-$51,000$34,000$34,000$6,462
Q: pays $520 at the end of each month. How much of Payment 37 will be interest? (Do not round the…
A: The interest is a cost associated with lending or borrowing money. It is the borrowing cost that you…
Q: The Saskatchewan Roughriders started a rainy day savings fund 3 years ago to help pay for stadium…
A: Quarterly deposit = $19,000Interest rate = 5.5%Number of years = 3 yearsCompounding frequency…
Q: A Treasury bond with 11 years to maturity is currently quoted at 113:9. The bond has a coupon rate…
A: A Bond is a debt investment which is issued by a borrower to the investor, it is usually used by…
Q: You are given the following Information concerning three portfollos, the market portfolio, and the…
A: The Sharpe ratio, Treynor ratio, and Jensen's Alpha serve as benchmarks for evaluating investment…
Q: Halloween Costumes Unlimited is considering a new 3-year store expansion project that requires an…
A: Net Present value refers to the Capital budgeting technique helps in evaluating the profitability…
Q: You are looking to buy a car. You can afford $600 in monthly payments for five years. In addition to…
A: Car amount that can be afforded is equal to the present value of the monthly payments and the down…
Q: Jennifer is the owner of a video game and entertainment software retail store. She is currently…
A: Time Value of MoneyThe time value of money (TVM) is a financial matric that refers to the idea that…
Q: You have $3,000 on a credit card that charges a 20% interest rate. If you want to pay off the credit…
A: Compound = Monthly = 12Present Value of Payment = pv = $3000Interest Rate = r = 20 / 12 %Time = t =…
Q: The expected return on Jeff's $260,000 stock portfolio is 24.3% and the dividend yield is 1.8%. How…
A: The answer is Jeff should sell 1.8% of his portfolio holdings every year.Here's the…
Q: Please show how to solve this unsing excel and please show all formulas in the spreadsheet. You…
A: 1CHOICE tobe made: Choice b 6.65% Rate,0.3 point 2Choice c is not properly priced. Amount of…
Q: As an Investment Analyst who researches and analyses markets, companies, and stocks to be invested…
A: Microsoft Corporation is a multinational technology company based in Redmond, Washington. Founded by…
Q: Polk Software Inc. has a quick ratio of 2.00x, $32,850 in cash, $18,250 in accounts receivable, some…
A: Inventory turnover ratio is one of efficiency ratio being used in business. This shows how many…
Q: Ninecent Corporation has a target capital structure of 65 percent common stock, 10 percent preferred…
A: Weight of common Equity stock (WE) = 65% or 0.65Weight of Preference stock (WP) = 10% or 0.1Weight…
Q: A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a…
A: Optimal risky portfolio is one which gives the highest risk to reward ratio and lies on the tangent…
Q: The interest rate for the first five years of a $91,000 mortgage loan is 5.25% compounded…
A: Amortization of loan refers to the systematic and regular repayment of the loan and interest amount…
Q: Suppose you purchase a $1,000 TIPS on January 1, 2021. The bond carries a fixed coupon of 3 percent.…
A: Coupon paymentsCoupon payments refer to the periodic interest payments that bond issuers make to…
Q: As an Investment Analyst who researches and analyses markets, companies, and stocks to be invested…
A: Investment analysis is the process of assessing different market entities, including stocks and…
Q: am. 118.
A: The objective of this question is to calculate the remaining mortgage balance after 15 years of…
Q: Show that it is possible to replicate the stock payoff by borrowing and buying a call option.
A: The current stock price is $50 per share, that call options can be purchased at an exercise price of…
Q: What is the single monthly mortality for seasoned 50 PSA, 200 PSA, and 400 PSA mortgages if the 100…
A: Single Monthly Mortality( SMM) : 1. Singlemonthly mortgage is a way to gauge the prepayment risk of…
Q: On May 1, 2024, Joe purchased $290,000 in zero-coupon bonds that mature on May 1, 2044. The bonds…
A: To calculate the price Joe paid for the zero-coupon bonds, we can use the present value formula. The…
Q: corpac Corporation has a dividend yield of 1.4%. Its equity cost of capital row at a constant rate.…
A:
Q: a. $64,000, 15-year loan at 7.00 percent. b. $140,000, 30-year loan at 5.50 percent. c. $104,000,…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
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
Step by step
Solved in 1 steps
- Sam would like to use the PMT function in Excel to calculate the monthly payments on a car loan of $35,000 which is to be paid off in full after 3 years. Interest is charged at a rate of 4.43% per year and the payment to the loan is to be made at the end of each month. Which function argument is correct? (Reminder: =PMT(rate, nper, pv, [FV], [type]) =PMT( 4.43%, 36, -35000) =PMT( 4.43%/12, 36, -35000) =PMT( 4.43%/12, 3, -35000) =PMT( 4.43%, 3, -35000)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 you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $989 per month, and the total finance charge is $9,504. After 25 months, you decide to pay off the loan. After calculating the finance charge rebate, find your loan payoff (in $). (Round your answer to the nearest cent.) Need Help? Read It Watch It Master It
- What is the monthly payment for a 5 year new car loan, when the nominal annual interest is 6%. After the down payment and other up-front charges, the amount borrowed is $21,000. Show your calculations and results using two methods: Use Engineering Economy factors and the compound interest tables found in Appendix C. Using spreadsheet. Set up table with known values and use Excel payment function (PMTThe formula below finds the monthly payment for a loan (car, mortgage, student): P=I (r/1-(1+r)-n ) P = monthly payment I = initial loan amount borrowed r = monthly interest rate n = number of months to pay off the loan 5. Assume you decide to take a 5-year car loan, with a 3.25% APR paid monthly. Insert the numbers you have so far into the formula above and simplify as much as possible. Show any in-between steps you do. (Note: simplify means to calculate the parts of the equation that you can so far.) 6. Use your simplified formula from above to answer: What is the largest amount you can borrow for the car if you can afford a $350/month payment? Show work.you are analyzing a GPM. the terms are $60,000 loan amount, 9% note rate, 30 years, monthly payments, OFV, payments in year one based based upon 7%, and payment in year two based on 8%. how much will you owe on this loan at the end of the second year? Please assist, using HP 10bII+.
- Suppose that you borrow $10,000 for four years at 8% toward the purchase of a car. Use PMT = to find the monthly payments and the total interest for - nt 1- the loan. The monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.) The total interest for the loan is $ (Use the answer from part (a) to find this answer. Round to the nearest cent as needed.)Suppose you want to borrow $90,000 and you find a bank offering a 20-year loan with an APR of 5%. a. Find your regular payments if you pay n = 1, 12, 26, 52 times a year. b. Compute the total payout for each of the loans in part (a). c. Compare the total payouts computed in part (b). a. The payment for n = 1 would be $ The payment for n = 12 would be $ The payment for n = 26 would be $ The payment for n= 52 would be $ (Do not round until the final answer. Then round to the nearest cent as needed.)Suppose that you decide to borrow $15,000 for a new car. You can select one of the following loans, each requiring regular monthly payments. Installment Loan A: three-year loan at 5.9% Installment Loan B: five-year loan at 4.8% P Use PMT = to complete parts (a) through (c) below. - nt 1- 1+ a. Find the monthly payments and the total interest for Loan A. The monthly payment for Loan A is $. (Do not round until the final answer. Then round to the nearest cent as needed.)
- Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $985 per month, and the total finance charge is $9,360. After 25 months, you decide to pay off the loan. After calculating the finance charge rebate, find your loan payoff (in $). (Round your answer to the nearest cent.) $Suppose that you decide to borrow $13,000 for a new car. You can select one of the following loans, each requiring regular monthly payments. Installment Loan A: three-year loan at 6.3% Installment Loan B: five-year loan at 4.8% P. Use PMT = to complete parts (a) through (c) below. - nt 1- a. Find the monthly payments and the total interest for Loan A. The monthly payment for Loan A is $. (Do not round until the final answer. Then round to the nearest cent as needed.) The total interest for Loan A is $. (Round to the nearest cent as needed.) b. Find the monthly payments and the total interest for Loan B. The monthly payment for Loan B is $. (Do not round until the final answer. Then round to the nearest cent as needed.) The total interest for Loan B is $. (Round to the nearest cent as needed.) MacBook AirConsider a student loan of $10,000 at a fixed APR of 6% for 4 years. a. Calculate the monthly payment. b. Determine the total amount paid over the term of the loan. c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest. a. The monthly payment is $. (Do not round until the final answer. Then round to the nearest cent as needed.)