Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Create the amortization spreadsheet and answer the following questions for a $350,000 15-year fixed-rate, constant-payment mortgage loan that is partiallyamortizing with a balloon payment of $100,000. The contract interest rate is 4% with monthly payments. Up-front discount points on the loan are 4%, and there is a 1% prepayment penalty.
please post spreadsheet with formulas visible
a) What is the APR (annual percentage rate) on the loan – assuming that there is no early prepayment on the mortgage?
b) What is the EAR (effective annual rate) on the loan if it prepaid at the end of year 7?
c) What is the monthly mortgage payment during month 160?
d) How much cumulative interest is paid during the 14th year of the mortgage?
What is the firm's average accounts receivable balance?- If the variable cost of each product is 65 percent of sales, what is the average investment in accounts receivable?
The annual standard deviation of returns on Stock A’s equity is 31% and the correlation coefficient of these returns, with those on the market index (S&P 500 index), is 0.82. Comparable numbers of Stock B are 34% and 0.64. What can you say about Stoc..
what do you mean by financial index and commodity index?method of index uses in calculation?weighted average method?how
ZXC has 20 annual lease payments remaining in its contract. The next one for $2.5m is due in 4 months. The payments decrease with the equipment value by 4% per year. Using a 12% discount rate, what is today’s present value of the remaining lease paym..
Dividend valuation with a constant growth model is similar to a growing perpetuity problem. Yield to maturity reflects the current market rate and it is the appropriate discount rate that matches the present value of the bond's cash flow stream and p..
One of the unpleasant secrets about using your credit card for a cash advance is that there is usually a 6 to 8 percent upfront fee on the amount. The APR on the cash advance is typically lower than the APR for normal purchases. Payments do not apply..
A manufacturer of video games develops a new game over two years. This costs $850,000 per year with one payment made immediately and the other at the end of two years. When the game is released, it is expected to make $1.2 million per year for three ..
We learn about how much debt should a firm take or in other words, we learn about a firm's capital structure. Please give your thoughts on this.
You are running a hot Internet company. Analysts predict that its earnings will grow at 30% per year for the next five years. After that, as competition increases, earnings growth is expected to slow to 2% per year and continue at that level forever...
Robbie Barrow just purchased a risk-free US Treasury note having 3 years to maturity and an annual coupon rate of 7.0 percent. Unlike standard US Treasury notes, the coupon/interest payments for this Treasury note are made once each year. determine t..
Oz Corp. is now in the final year of a project. The equipment originally cost $9700, and the asset has been 60% depreciated. Oz can sell the used equipment today for $1500, and its tax rate is 35%. The equipment's after-tax net salvage value is $____..
"The more data used in forecasting, the more accurate the forecast will be." Do you agree with this statement? If not, provide an example of when this might not be true.
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd