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!
Today, John borrowed $40,000 from the bank. His initial plan is to pay his entire principal and interest amount in 48 months. He plans to pay some extra payment for the first year to pay off the debt earlier. As an excel programming trainer, please do the following requirements: a) If He plans to make extra payment of $600 every month. Write a flexible program that returns the correct loan amortization schedule (including month, interest and payment, repayment of principal and remaining balance) and the correct output section for any change in items in input section. You need to roundup the actual loan period sine partial period does not make sense. You have to use the if statement and the program should be flexible with respect to all variables in the input section ( 20 points) b) If there is no extra payment, how much more interest payments John would save if the original loan term is 24 month instead of 48 month. c) John needs to find out when it is the first time the remaining balance hit below $10,000, so he may exercise the option to prepay off the rest of the loan. You need to use the excel function such Use functions such as Vlookup , IF to solve this question. You are allowed to create additional column to assist your problem solvoing. But you can not manually find out the answer, you still need to make the solution flexible. d) If the extra payment $600 starts from month 1 till the end of month 12, please redo the question, find out the actual loan payment, and the first time your balance hit below $10,000.
James Corporation is considering the credit application of a customer. The customer is expected to buy $5000 worth of material from James every month in future, and pay for it within a month.
Suppose a real estate investment offers cash flows of $100,000 per year for five years. At the end of five years, the building is expected to be worth $1,100,000. What is the most you should pay for the investment if your opportunity cost of capital ..
You are thinking about buying a share of Glencoe Industries, which has a current market price of $30.00 per share. Glencoe expects to pay a dividend of $1.125 per share next year. Your required rate of return on these types of investments s 6% and is..
You are evaluating two different silicon wafer milling machines. The Techron I costs $225,000, has a three-year life, and has pretax operating costs of $58,000 per year. The Techron II costs $395,000, has a five-year life, and has pretax operating co..
Please research Negative interest rate (NIRP) or Zero interest rate (ZIRP) policies and explain the following; How does this affect the bond market? Who wins and who loses in this environment?
The cost of debt is lower than the costs of stocks. Cost of Preferred stock is higher than the cost of common stocks.
The 2014 balance sheet of Sugarpova’s Tennis Shop, Inc., showed $580,000 in the common stock account and $3.5 million in the additional paid-in surplus account. The 2015 balance sheet showed $620,000 and $3.9 million in the same two accounts, respect..
forecasting interest rates based on prevailing conditions.consider the prevailing conditions for the following factors
Many large corporations, such as General Motors, have written off large amounts of their nonperforming (or poorly performing) assets as they have shrunk their operations. What is the impact of these asset write-offs on the future return on assets, fu..
Suppose that the daily volatilities of these two assets are 1.8% and 1.2% respectively, and that the coefficient of correlation between their returns is 0.6. What is the 10-day 97.5% VaR for the portfolio? By how much does diversification reduce the ..
A stock has had returns of -26 percent, 6 percent, 34 percent, -5 percent, 28 percent, and 19 percent over the last six years. What are the arithmetic and geometric returns for the stock?
You own 400 shares of Stock A at a price of $70 per share, 450 shares of Stock B at $85 per share, and 850 shares of Stock C at $31 per share. The betas for the stocks are 0.8, 1.6, and 0.6, respectively. What is the beta of your portfolio?
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