Prepare amortization table by using ms excel

Assignment Help Finance Basics
Reference no: EM133119350

On december 31, loren billingsley bought a yacht for $60,000, paying $15,000 down and agreeing to pay the balance in 10 equal annual installments include both principal and 9% interest on declining balance. How big would the annual balance also prepare amortization table by using ms excel

Reference no: EM133119350

Questions Cloud

Number of assets in the portfolio : Explain what happens to the risk of a portfolio as the number of assets in the portfolio is increased.
What is the rate of return on bee ltd shares : The share price for Bee Ltd at 1 July 2020 was $3.40 and at 30 June 2021 was $4.80. You have collected the following per share dividend data for 2020 and 2021:
Distinguish between vulnerability-threat and control : Distinguish between vulnerability, threat, and control. List three reasons people might be reluctant to use bio-metrics for authentication.
Present value of the cash flows : The appropriate discount rate for the following cash flows is 6.88 percent per year. CF1 = 2,380, CF2 = 0, CF3 = 3,820, CF4 = 2,070. What is the present value o
Prepare amortization table by using ms excel : On december 31, loren billingsley bought a yacht for $60,000, paying $15,000 down and agreeing to pay the balance in 10 equal annual installments include both p
Intelligence assets and information from foreign penetration : You may choose to act as the United States brainstorm ways to protect its intelligence assets and information from foreign penetration
Calculate the expected return of portfolio : You have invested $25,000 in Pfizer stock and $35,000 in Moderna stock. Pfizer stock has an expected return of 18% and volatility equal to 43%. Moderna stock ha
What is the historical standard deviation : What is the historical standard deviation? Please solve on a paper.
What is the future value : What is the future value of $1,575 a year for 25 years at 6.3 percent interest rate, compounded annually?

Reviews

Write a Review

Finance Basics Questions & Answers

  What is systematic and nonsystematic risk of each security

What is systematic and nonsystematic risk of each security? For which portfolio had an average return in excess of that predicated by the CAPM?

  Calculate pcd return on sales

PCD managers are evaluated and rewarded on the basis of ROI defined as operating income divided by total assets. Barkley Industries expects its divisions to increase ROI each year.

  Expected rate of return on diversified industries stock

There is a 5 percent probability of a boom and a 70 percent chance of a normal economy. What is your expected rate of return on your Diversified Industries.

  What is the opportunity cost of not replacing the truck now

What is the opportunity cost of not replacing the truck now? What is the annual equivalent cost of owning and operating the truck for 2 more years?

  Calculate the wacc

Calculate the WACC

  Determine the required rate of return of csl limited

CSL Limited is considering installing a production line to manufacture the Covid-19 vaccine, which was successfully developed by an Australian university.

  Calculate the internal rate of return for each alternative

The company's tax rate is 50 percent, and its cost of capital is 11 percent. Calculate the internal rate of return for each alternative.

  Get two people to engage in the gambles

Why is this not an arbitrage opportunity and how could you make it one, assuming you could get two people to engage in these gambles?

  Capital asset pricing model

Assume the expected return on the market portfolio is 13.8 percent and the risk-free rate is 6.4 percent. Solomon Inc. stock has a beta of 1.2. Suppose the capital-asset-pricing model holds.

  Explain unequal distribution of wealth matter in terms

Explain unequal distribution of wealth matter in terms of public policy and why does it matter. Analyze and take a position on unequal distribution of wealth and its influence on demographic changes

  How are risk classes often used to apply radrs

How are risk classes often used to apply RADRs?

  What coupon rate should the company set

Coccia Co. wants to issue new 16-year bonds for some much-needed expansion projects. The company currently has 8 percent coupon bonds on the market that sell for $1,065, make semiannual payments, and mature in 16 years.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd