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!
Assignment 3: Rate Calculations Submit the two parts of this assignment in a spreadsheet. It is acceptable to put both parts on one tab or put them in separate tabs. Grading for Assignment 3 will be performed by substituting several numbers for the boxes above each table. So you can insert any value you wish in the boxes at the top of the table o determine if your table works correctly. Note that if you are using Excel 2003, the Nominal and Effect functions may not be available to you. The equivalent equations are in this week's content. The use of either functions or equations is acceptable. Part 1: Create a spreadsheet table that shows for a particular Compounding Frequency and Nominal Annual Rates (NAR) for 10% to 3%, the corresponding Periodic Interest Rate (PIR) and Effective Annual Rate (EAR). Use the format as shown below. A manual change in the Compounding Frequency in the box above the table should cause the PIR and EAR columns in the table to automatically change for all of the NARs of 10% to 3%. Do this by entering the appropriate equations in the PIR and EAR columns. Format the PIRs and EARs as percentages with two decimal places (xx.xx%) Compounding Frequency ? Times Per year NAR PIR EAR 10% 9% 8% 7% 6% 5% 4% 3% Part 2: Create a second spreadsheet table that shows the monthly car payments for a particular loan amount and length of the loan in years. That is, the resulting table should enable one to type in any loan amount and length of the loan (examples are shown in boxes at the top of the table), and the monthly payments will automatically be shown for the NARs of 3% to 8% that have monthly compounding. Format the monthly payments as dollars with 2 decimal places ($xx.xx) Loan Amount $20,000 Length 6 years NAR Monthly Payment 3% 4% 5% 6% 7% 8%
you have won a contest and now must decide which prize you want. with prize a you receive 5000 today and another 5500
Assume that an investor is offered a choice of a risk-free government bond or a high-risk corporate stock. Further assume that the expected return is the same for both. According to one of the axioms of finance, which investment would be chosen?
Research and discuss the differences and importance of : MPFS, IPPS, OPPS and DMEPOS. Which provider type is paid by which method? Determine the payment expectations for each type?
Computation of after-tax cost of debt is planning to place privately with a large insurance company
a 20-year bond pays 12 on face value of 1000. if similiar bonds are currently yielding 9 what is the market value of
Suppose next year the Baldwin Company generates $20,000 in net profit, pays $10,000 in dividends, assets change to $151,000, and common stock remains unchanged. What must their total liabilities be next year?
calculating cost of equity cost of retained earnings based on discounted cash flow c a p m and bond cost plus premium
turner corp. has debt of 230 million and generated a net income of 121 million in the last fiscal year. in attempting
5. A factory costs $800,000. You reckon that it will produce an inflow after operating costs of $170,000 a year for 10 years. If the opportunity cost of capital is 14%, what is the net present value (NPV) of the factory?
A bank gives you a bid-ask quote on the BGN (Bulgarian lev), of 0.77 - 0.87 USD/BGN. What is the percentage bid-ask spread?
Do Apple Inc issue convertible securities and If so why, if not why not. How about warrants
in what ways do you think information useful for investors in assessing future cash flows differs from that useful for
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