Suppose a couple in their early 30s is planning to buy a new HDB flat. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose a couple in their early 30s is planning to buy a new HDB flat. The selling price of the HDB flat is $350,000. The couple has sufficient cash to make a down-payment of $35,000 (from CPF and other savings), and wishes to get a loan from HDB for the balance. The loan from HDB is a 25-year fixed-rate loan at 2.6% APR. Assume monthly compounding and that monthly payments begin in one month. While waiting to try their luck in the BTO queueing process, the couple also wishes to consider the possibility of buying from the resale market directly. Assume they can afford $2000 monthly payments and also go for a 25-year HDB loan at 2.6% APR. Demonstrate your understanding of Time Value of Money, by calculating the monthly mortgage payment if they buy BTO flat directly from HDB; and figuring out what is the maximum price of a resale HDB flat they can afford, given their financial circumstances. (b) The couple is expecting a child shortly and wish to make plans to cover their child's overseas education in 18 years' time. Current fees are $7000 per annum and they assume these will rise at 5% per annum. The following table shows the amount of tuition fees for four years from Year 18 to Year 21. Tuition fees at: Year 18 Year 19 Year 20 Year 21 Amount $16,846 $17,689 $18,573 $19,502 The couple assumes their investments will earn 6% each year. Demonstrate your understanding of Time Value of Money, by analysing how much money they should contribute now if they plan to make equal payments starting next year for 17 years. (c) Question 2 A fund manager is required to submit an investment proposal to the Investment Committee on the merits of investing in ABC Corp. As an investment analyst supporting the team, you have been asked to assist in analysing the bonds and common stock of the company. You have found the company to have a target capital structure of 70% equity and 30% debt, and gathered the following information: (a) Identify three (3) groups of professionals who will build financial models, and explain why they do so. (b) (c) Current price of bonds Bonds par value Coupon rate Earnings per share- most recent year Expected growth rate of dividends Dividend payout ratio Required rate of return Current price of common stock 97% of par $1000 8% $2.00 5.10% 60% 12.60% $18 The bonds were issued 10 years ago, and mature 15 years from today. Coupon payments are distributed annually. Analyse the YTM of the bonds (including the verification of your answer with an appropriate Excel function), and the circumstances where bonds will be trading at discount, premium or at par. Calculate the company's share price using the Dividend Discount Model, and determine whether it is worth investing at current price. Compose a memo to the fund manager, of not more than 500 words, about your findings on the bond and common stock of ABC Corp, and provide your opinion on the relative merits of investing in bond vs common stock. Question 3 (a) A project has 6 million cashflow each year for 5years, payback period of 4 years and rate of return 11%. Solve for the project's NPV, by showing all relevant workings. Verify your answer with an appropriate Excel function. Indicate whether you should proceed with the project. (b) (c) A company is evaluating two mutually exclusive projects A and B, and both have conventional cashflows (i.e. all inflows after the initial outflow). Project A has an IRR of 14% and the NPV profiles of Project A and Project B cross-over at 10%. Illustrate, using a graph or any other means, the range of values of cost of capital, when the NPV rule and IRR rule will not lead to the same decision. Discuss the multiple issues of using IRR as a decision rule for choosing a project. Suppose a couple in their early 30s is planning to buy a new HDB flat. The selling price of the HDB flat is $350,000. The couple has sufficient cash to make a down-payment of $35,000 (from CPF and other savings), and wishes to get a loan from HDB for the balance. The loan from HDB is a 25-year fixed-rate loan at 2.6% APR. Assume monthly compounding and that monthly payments begin in one month. While waiting to try their luck in the BTO queueing process, the couple also wishes to consider the possibility of buying from the resale market directly. Assume they can afford $2000 monthly payments and also go for a 25-year HDB loan at 2.6% APR. Demonstrate your understanding of Time Value of Money, by calculating the monthly mortgage payment if they buy BTO flat directly from HDB; and figuring out what is the maximum price of a resale HDB flat they can afford, given their financial circumstances. (b) The couple is expecting a child shortly and wish to make plans to cover their child's overseas education in 18 years' time. Current fees are $7000 per annum and they assume these will rise at 5% per annum. The following table shows the amount of tuition fees for four years from Year 18 to Year 21. Tuition fees at: Year 18 Year 19 Year 20 Year 21 Amount $16,846 $17,689 $18,573 $19,502 The couple assumes their investments will earn 6% each year. Demonstrate your understanding of Time Value of Money, by analysing how much money they should contribute now if they plan to make equal payments starting next year for 17 years. (c) Question 2 A fund manager is required to submit an investment proposal to the Investment Committee on the merits of investing in ABC Corp. As an investment analyst supporting the team, you have been asked to assist in analysing the bonds and common stock of the company. You have found the company to have a target capital structure of 70% equity and 30% debt, and gathered the following information: (a) Identify three (3) groups of professionals who will build financial models, and explain why they do so. (b) (c) Current price of bonds Bonds par value Coupon rate Earnings per share- most recent year Expected growth rate of dividends Dividend payout ratio Required rate of return Current price of common stock 97% of par $1000 8% $2.00 5.10% 60% 12.60% $18 The bonds were issued 10 years ago, and mature 15 years from today. Coupon payments are distributed annually. Analyse the YTM of the bonds (including the verification of your answer with an appropriate Excel function), and the circumstances where bonds will be trading at discount, premium or at par. Calculate the company's share price using the Dividend Discount Model, and determine whether it is worth investing at current price. Compose a memo to the fund manager, of not more than 500 words, about your findings on the bond and common stock of ABC Corp, and provide your opinion on the relative merits of investing in bond vs common stock. Question 3 (a) A project has 6 million cashflow each year for 5years, payback period of 4 years and rate of return 11%. Solve for the project's NPV, by showing all relevant workings. Verify your answer with an appropriate Excel function. Indicate whether you should proceed with the project. (b) (c) A company is evaluating two mutually exclusive projects A and B, and both have conventional cashflows (i.e. all inflows after the initial outflow). Project A has an IRR of 14% and the NPV profiles of Project A and Project B cross-over at 10%. Illustrate, using a graph or any other means, the range of values of cost of capital, when the NPV rule and IRR rule will not lead to the same decision. Discuss the multiple issues of using IRR as a decision rule for choosing a project.
Expert Answer:
Answer rating: 100% (QA)
a Monthly mortgage payment for BTO flat To calculate the monthly mortgage payment for the BTO flat we can use the formula for a fixedrate loan M P r 1... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Kirk and Luann, a couple in their early 30s, have hired you to prepare financial statements for them. During your meeting on September 14, 20x1, a discussion of their financial situation reveals the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
What will be the sum of third proportional to 18 and 54 and fourth proportional to 12, 18 and LCM of 12 and 18? 1. 162 2. 216 3. 612 4. 256 526 5.
-
At December 31, balances in Manufacturing Overhead are: Shimeca Companydebit $1,200, Garcia Companycredit $900. Prepare the adjusting entry for each company at December 31, assuming the adjustment is...
-
Multiply. Assume that all variables represent positive real numbers. V143pqr
-
You are newly employed by Silver and Gold Ltd to promote their environmental approach to mining for minerals. In their annual report and promotional material, Silver and Gold Ltd states that...
-
Massey Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $640,000 is estimated to result in $270,000 in annual pretax cost savings....
-
Find resources that confirm the importance of budgeting to organizations and answer the question below. Using your work experience think about how budgets can influence the choices made by top...
-
Determine the objectives of the test. You are auditing both quantities and pricing of the final inventory accumulation. a. Explain the assertions that you are testing. b. Explain the evidence that...
-
Create a class called Book that stores information such as the title, writer's list, and year published. Implement the necessary constructors as well as the getters and setters for the class Book. In...
-
A vessel having a volume of 3 cu ft contains 0.5 lb of air at atmospheric pres- sure. Additional air is forced into the vessel until the total weight of air is 1.375 lb. If the temperature remains...
-
20. As a shaft's journal passes through a plain bearing, one edge of the bearing rubs against the left side of the journal and the other edge rubs against the right side of the journal. The cause of...
-
What type of coordinates determines each new tool position based on the tool's current position? POSSIBLE ANSWERS: O Axial coordinates Polar coordinates Incremental coordinates Absolute coordinates
-
6. Three identical small Styrofoam balls (m = 2.05g) are suspended from a fixed point by three nonconducting threads, each with a length of 45.1cm and with negligible mass. At equilibrium the three...
-
4. Where are revolved sections placed in a print? A. In between section lines B. Cutting planes are used to identify their locations O C. In between break lines O D. Stand-alone
-
The Enormous State University Good Works Society recently raised funds for three worthwhile causes: the Math Professors' Benevolent Fund (MPBF), the Society of Computer Nerds (SCN), and the NY Jets....
-
Distinguish between the work performed by public accountants and the work performed by accountants in commerce and industry and in not-for-profit organisations.
-
Consider the market for canned tuna fish. The labels fall into three categories: premium (Bumble Bee, Starkist, Chicken-of-the-Sea), medium-quality (Three Diamonds, Geisha), and store-brand. There is...
-
Calculate the yield to maturity for each of the following bonds. a. A 20-year bond with a coupon of $100, principal payment at maturity of $2,000, and a current price of $2,000. b. A 5-year bond with...
-
It's Tuesday and Ted is making plans for the end of the week. There are parties on Wednesday, Thursday, Friday, and Saturday nights. He has a big test on the following Monday, so he only has enough...
-
For the CPM Calculation Exercise found on the companion website, determine the ES, EF, LS, LF, FF, and TF for each activity. Identify the activities through which the critical path runs. How many...
-
Why is the bar chart not an adequate planning and scheduling tool?
-
What are impediments to planning, both at the beginning of a project and throughout the project?
Study smarter with the SolutionInn App