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.
cost of goods sold, $450,000 in operating expenses (including a depreciation expense of $150,000), with a tax liability equal to 35% of the firm's taxable income. What is the net income of the firm for the year?
A commercial client is seeking use of a machine for production purposes in his business. Suggest which products might be useful to them, and how they are consistent with the aims of Islamic banking?
Suppose the exchange rate is $1.547 per euro. If the dollar depreciates by 11% against the dollar, how many Euros would a dollar buy tomorrow?
A company is 36% financed by risk-free debt. The interest rate is 9%, the expected market risk premium is 7%, and the beta of the company’s common stock is 0.63. What is the company cost of capital? What is the after-tax WACC, assuming that the compa..
Company Z issued bonds with detachable warrants several years ago. Each warrant allows the holder to purchase one share of stock at $30 per share. The stock has a beta of 1.3. How much would an investor likely be willing to pay for the warrant over a..
Discuss primary financial statements published by a corporation, the various classifications used in a balance sheet-What is the purpose of a Balance Sheet? What information does it provide?
Assuming IBM’s historical “LT (Long-term Debt/Equity) is 100 percent, how does it currently stand? Generally speaking, is that good or bad? Assuming its historical return on assets is 10 percent, how does it currently stand? Generally speaking, is th..
Wendy's boss wants to use straight-line depreciation for the new expansion project because he said it would give higher net income in earlier years and give him a larger bonus. The project will last 4 years and requires 1, 700,00 of equipment. What w..
You currently own 600 shares of JKL, Inc. JKL is an all equity firm that has 75,000 shares of stock outstanding at a market price of $40 a share. The company's earnings before interest and taxes are $140,000. JKL has decided to issue $1 million of de..
Two projects are considered for evaluation. Project A has a cost of $10000 and is expected to produce benefits of $3000 per year for five years. Project B costs $25000 and is expected to produce cash flows of $7500 per year for five years. Calculate ..
Patton Paints Corporation has a target capital structure of 45% debt and 55% common equity, with no preferred stock. Its before-tax cost of debt is 13% and its marginal tax rate is 40%. The current stock price is P0 = $22.50. The last dividend was D0..
You have a loan of $25,000 and will repay the loan over 5 years at 8% interest. What is your loan payment? What does the amortization schedule look like?
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