Construct an amortization schedule for a $10,000, 4% annual rate loan with 12 equal monthly payments. Can anyone please show how to use formulas to get the answer please
Q: You work for a pharmaceutical company that has developed a new drug. The patent on the drug will…
A: Present value is capital budgeting technique which we can know the present value of future benefits.…
Q: Carson Trucking is considering whether to expand its regional service center in Mohab, UT. The…
A: Here, Initial Investment $9,000,000.00Net Cash Inflows $4,000,000.00Salvage Value at the end of 6th…
Q: Lohn Corporation is expected to pay the following dividends over the next four years: $11, $9, $5,…
A: Dividend for year 1, D1 = $11Dividend for year 2, D2 = $9Dividend for year 3, D3 = $5Dividend for…
Q: First City Bank pays 5 percent simple interest on its savings account balances, Second City Bank…
A: First City Bank Interest rate = 5% simple interestSecond City Bank Interest rate = 5% compounded…
Q: 3. You are purchasing an annuity that will pay you 15,000 a year for 5 years, beginning in year 20.…
A: Annuity = a = $15,000Number of Payment = n = 5Time = t = 20 - 1 = 19 Years (Because of Beginning…
Q: Helga is considering the purchase of a small restaurant. The purchase price listed by the seller is…
A: Project decision making is the process of evaluating whether or not to invest in a particular…
Q: Within the Single Index Model paradigm, which of the following would contribute to higher overall…
A: Within the Single Index Model (SIM), which is a model used in finance to estimate the expected…
Q: Andrew and Emma Garfield invested $6,100 in a savings account paying 4% annual interest when their…
A: Variables in the question:At t=0, amount invested=$6100Annual interest=4%Annual deposit (for 16…
Q: Jacques just won the lottery and must choose between three award options: 1. A lump sum of…
A: Three options of Annuity payment are given and we have to determine the present value with different…
Q: If you start making $130 monthly contributions today and continue them for five years, what's their…
A: The PV of an investment refers to the value of the cash flows of the investment after the cash flows…
Q: e Narnian stock market had a rate of return of 45% last year, but the inflation rate was 30%. What…
A: Real rate of return is the rate of return after considering the impact of the inflation on rate of…
Q: Sales Operating costs excluding depreciation EBITDA Depreciation EBIT Interest em: At the end of…
A: 1.EBITDA = Sales - Operating cost excluding depreciation2.EBIT = EBITDA - Depreciation3. EBT = EBIT…
Q: Suppose that $1,000 is deposited into an account paying simple interest of 8% annually. At the end…
A: Principal Amount = p = $1000Interest Rate = r = 8%Time = t = 5 YearsExpected Future Value = $1400
Q: 20) A C corporation earns $8.30 per share before taxes and the company pays a dividend of $2.00 per…
A: Dividend = d = $2Corporate Tax Rate = ct = 39%
Q: For Cash flow to creditors, why did you add it? Isn't CFC= Interest- Long Term Deb
A: First let us define what cash flow to creditors is. CFC is the net cash outflows that a company pays…
Q: Donna enters into an investment contract that will guarantee her 4% per year if she deposits $3,500…
A:
Q: Determine the interest payment for the following three bonds (Assume a $1,000 par value.) (Round…
A: Bonds are a kind of loan in which only interest payments done each period and par value is paid on…
Q: Within a family of funds, charges for exchanges generally are small for each transaction, and the…
A: Please note that the correct option is not provided in the snapshot. A "family of funds," also known…
Q: . A $1,000 Expo Corp. bond has a coupon rate of 5%, pays interest semiannually, and matures in six…
A: Compound = Semiannually = 2Face Value = fv = $1000Coupon Rate = 5 / 2 = 2.5%Time = t = 6 * 2 =…
Q: A bond is issued with a coupon of 4% paid annually, a maturity of 36 years, and a yield to maturity…
A: The problem statement wants to calculate the rate of return being generated by selling the bonds in…
Q: XYZ's stock price and dividend history are as follows: Beginning-of- Dividend Paid Year Price at…
A: The average return on a stock is calculated using the arithmetic return and the geometric return is…
Q: What are your posible revenues that you can earn to meet your goal
A: The equation to determine the profit is as follows. By rearranging the formula, we can determine the…
Q: You invested 260 in a mutual fund today that pays 6.3 percent interest annually. How long will it…
A: Present Value = pv = 260Interest Rate = r = 6.3%Future Value = fv = 260 * 2 = 520
Q: Bravo Manufacturing Company is negotiating with a customer for the lease of a large machine…
A: Lease is kind of agreement in which there are no initial investment and only periodic payments are…
Q: A 5%-coupon, interest-only, 30-year Treasury Bond is an asset that makes semiannual payments (that…
A: Time to Maturity = 30 YearsPayment Frequency = Semi-annuallyPayment Amount = $25Annual Opportunity…
Q: MLK Bank has an asset portfolio that consists of $90 million of 30-year, 9 percent annual coupon,…
A: Here, Coupon Rate9%Time to Maturity $ 30.00Face Valeu of Bond $ 1,000.00Current Price of Bond…
Q: Stamps Office Supplies recently reported $15,500 of sales, $8,500 of operating costs other than…
A: Sales = s = $15,500Operating Cost other than Depreciation = oc = $8500Depreciation = d = $1700Value…
Q: TraChem Corporation issues Series Z bonds and Series C bonds. Both bonds have par values of $10,000…
A: The problem case focuses on calculating the price of the series Z bond. It is a zero-coupon bond…
Q: A bond's credit rating provides a guide to its price. In December 2020, Aaa bonds yielded 5.4%, and…
A: Aaa Bond Yield = ra = 5.4%Bbb Bond Yield = rb = 6.4%Coupon rate = 10%Time = t = 5 yearsFace Value =…
Q: Assume all sales are one-time credit sales with a probability of collection of 96 percent. The…
A: Variables in the question:Probability of collection=96%Variable cost per unit=$1.67Sales price per…
Q: Problem 8-10 You are building a free cash flow to the firm model. You expect sales to grow from $1.6…
A: Here, in millionSales $ 1,600.00Sales After 5 years $ 2,000.00Growth Rate4.563955%Growth Rate…
Q: Pitts Industrial is planning to undertake a second line of business. With the new line of business,…
A: Growth Rate = 2% Cost of capital = 12%Current cost = $240 millionThe present value of the cost for…
Q: Your oldest daughter is about to start kindergarten in a private school. Tuition is $20,000 per…
A: Present value refers to the current value of the annuity fund that is determined by discounting…
Q: onsider the following pair of mortgage loan options for a $120,000 mortgage. Which mortgage loan has…
A: Mortgage loans are secured loans in which home is collateral and are paid by equal monthly…
Q: Can you please use the formulas in Excel. 15. Note the following information on two mutually…
A: Net Present Value (NPV):NPV is a financial metric that calculates the difference between the present…
Q: You are an analyst working for Goldman Sachs, and you are trying to value the growth potential of a…
A: To calculate the present value of all future growth opportunities for Big Industries, use the…
Q: The NPV of this project is $.
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Dax Industrial Systems has stock currently priced at $50.00 per share. If investors are earning a 7%…
A: P = whereP= current stock priceD = annual dividend payment per sharer = Required return
Q: n a CAPM world, what do you need to know in order to estimate an asset's expected return? Group of…
A: In CAPM we measure the rate of return of the stock based on the beta of the stock that is related to…
Q: You invested money in a savings account paying 9% interest seven years ago. The account is now worth…
A: Saving account refers to the account which is used by individual to save money securely while…
Q: Suppose that the current 1-year rate (1-year spot rate) and expected 1-year T-bill rates over the…
A: Year 1 current rate = R1Year 1 current rate= 6.00%Year 2 current rate = [{(1+R1)*…
Q: What is the concept of future value within the context of the larger overall concept of the time…
A: The concept of future value is a fundamental component of the broader idea known as the time value…
Q: What is the maximum Annual Percentage Rate (APR) you can afford if you want to borrow $5,200 for a…
A: Compound = Monthly = 12Present Value = pv = $5200Time = nper = 48Monthly Payment = pmt = $135
Q: a. Compute the rate of return on an equally weighted index of the three defense stocks for the year…
A: Price-Weighted Index:In the price-weighted index, each security is weighted by the relevant price…
Q: Create a single-variable data table in Excel highlighting the monthly payment as a function of the…
A: We can determine the monthly payment using the excel function PMT(). PMT requires the following…
Q: A coupon bond that pays semiannual Interest is reported in the Wall Street Journal as having an ask…
A: A bond is a financial instrument issued in the debt market by large business firms and governments…
Q: Condition Probability Grn Bond Stock A Stock B Market Recession 0.1 8.0% -22% 28% -13%…
A: Security market Line SML refers to the concept of capital asset procing model helps to determine the…
Q: A $1,000 Omega Corp. bond has an 8% coupon rate that is paid semiannually. The bond matures in three…
A: Compound = Semiannually = 2Face Value = fv = $1000Coupon Rate = 8/ 2 = 4%Time = nper = 3 * 2 =…
Q: A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a…
A:
Q: Tony Begay at Saguaro Funds. Tony Begay, a currency trader for Chicago-based Saguaro Funds, uses the…
A: a. Number of contracts bought = 5 Spot rate at maturity =$1.3981 /£1Forward rate = $1.4162/£The…
Step by step
Solved in 3 steps with 2 images
- Construct an amortization schedule (monthly) with the followings: House Price: 700,000 Down Payment: 20% of House Price Loan Period: 30 years Interest rate: 5.78% To get full credit, you must use Excel functions with relative cells to change the amortization schedule with variables such as price, interest, and load period. Please submit your Excel spreadsheet. (No other files are accepted)I need well explained answers by showing all steps and calculations, involving all formulas.. A $10 000 loan is to be repaid with semi-annual payments of $ 2500 for as long as necessary. If interest is at j12 = 12%, create a complete amortization schedule.Develop a complete amortization table for a loan of $4500, to be paid back in 24 uniform monthly installments, based on an interest rate of 6%. The amortization table must include the Payment Number, Principal Owed (beginning of period), Interest Owed in Each Period, Total Owed (end of each period), Principal Paid in Each Payment, Uniform Monthly Payment Amount. You must also show the equations used to calculate each column of thetable. You are encouraged to use spreadsheets. The entire table must be shown.
- Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $180,000 for 3 years at 10% compounded annually Period Balance Reduction Unpaid Balance Payment Interest $180,000 2$ %24 2 %24 %24 $0.00 Need Help? Read It Talk to a Tutor Submit AnswerConstruct the amortization schedule for a $8000 debt that is to be amortized in 6 equal quarterly payments at 2% interest per quarter on the unpaid balance. How much interest must be paid? After you are ready, choose the "Finish attempt" option, and then "Submit all and finish". After this, take a picture or scan your solution and upload it into the e-learning system. You should upload the solution in jpg or pdf format. Please, write legibly. If I can not read your solution, I can not give points either.A loan of $5,000 with interest at 7.75% compounded annually is amortized by equal payments at the end of each year for five years. 1. Show your financial calculator inputs for the payment calculation. 2. Create a full amortization schedule for the loan. A template is available in the Test folder (underneath the link to our test. You can fill in the Word file template and attach below,
- Create an amortization table for a $60,000 loan. We will assume payments are made monthly over 6 years at an interest rate of 4%. a.) First use a formula cell in your spreadsheet to calculate the monthly payment amount. b.) Create an amortization table for the 72 months. Your columns of your amortization table should include payment number, payment amount, interest paid each month, principle paid that month, amount paid on principal total, and the amount of principal remaining.Complete each requirement on a separate worksheet. Each requirement must have a user input section. Makeup and enter your own numbers for the user inputs for each requirement. Requirements: 1. Create a user input section for the user to input the annual effective interest rate and number of periods per year. Calculate the annual nominal interest rate. 2. The user can invest money at the end of each year. Create a user input section for the user to input the amount that they will invest at the end of each year. Using an annual interest rate of 9%, how much will the user have at the end of 7 years? 3. The user wants to save money to buy a new car 10 years from today. The new car will cost $125,000. Create a user input section for the user to input the amount that they can invest at the beginning of each year. What annual interest rate will they need to earn to have enough cash to buy the car 10 years from today? 4. The user wants to save $60,000.00 for a once in a lifetime…Find the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2% a. What formula should be used? b. What are you trying to find and what variable does it represent in the formula? c. Solve the problem showing all of your work (must show all steps!!) d. Interpet your answer using a complete sentence You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain" button to add pictures.
- Develop a general-purpose spreadsheet to calculate the balance due, principal payment, and interest payment for each period of a loan. The user inputs to the spreadsheet will be the loan amount, the number of payments per year, the number of years payments are made, and the nominal interest rate. Submit printouts of your analysis of a loan in the amount of $15,000 at 8.9% nominal rate for 36 months and for 60 months of paymentsSuppose that you need an amount of money which equals to $10000000. It is possible to find it from bank A at an annual interest rate of 18% under 12 equal payment. If the first payment will be 1 month later the day you used the loan. Find the CF (Cash Flow), the equal payments and prepare the amortization table.After completing a bachelors degree, you have $15,000.00 in student loans to pay back at an interest rate of 2.25% for 6 years. Follow the steps to show work used to calculate the monthly payment on this loan. Enter the values needed for the LEFT and RIGHT sides of the amortization formula. LOOK AT YOUR FORMULA SHEET. Be sure to use parentheses as shown in class and * to show multiplication: LHS: RHS: pymt. Hint Hint Now simplify the expressions from above and enter the final values for both sides below, keeping at least 6 decimal places: = pymt. Finish your calculation of the payment and enter your result, rounded to the nearest penny, in the table below. Then use the information to complete missing values in the table. SEE THE VIDEO BELOW IF YOU NEED HELP WITH THE TABLE (Round to the nearest cent) Month Monthly Payment Interest on Prior Balance Principle Outstanding Balance 1 2 3 Question Help: Video