Reference no: EM13829212
Instruction:
1.You are expected to show your working process and discuss your findings in details.
You need to work on the mini-projects in Excel. Your final mini-project report should be well-organized and typed in a WORD file. Please submit both your WORD report and Excel files.
Mini-Project 1: Mortgage Loan Analysis: Mr. Johnson plans to buy a new house at Bean Town in September 2014. The sale price of the house is $366,000. He is going to pay 20% down payments and borrow additional 80% from Wells Fargo with a 20-year, 3.875% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from October 2014 for a total of 20 years.
(1) Calculate the required monthly mortgage payment for Mr. Johnson.
(2) Construct the 2014~2020 amortization table for Mr. Johnson.
(1)Mr. Johnson should prepare his 2014 tax filings in early 2015. Estimate the total mortgage interest payments that he can use for his 2014 tax deduction.
Mini-Project 2: Capital Budgeting Analysis: The CS HighTech is planning a new investment project which is expected to yield cash inflows of $335,000 per year in Years 1 through 5, $266,000 per year in Years 6 through 9, and $218,000 in Years 10 through 15. This investment will cost the company $2,500,000 today (initial outlay). We assume that the firm's cost of capital is 8.5%.
(1) Draw a time line to show the cash flows of the project.
(2) Compute the project's payback period, net present value (NPV), profitability index (PI), internal rate of return (IRR), and modified internal rate of return (MIRR).
(3) Discuss whether the project should be taken.
|
What is the value of a share of procter & gamble stock
: 12.Procter & Gamble will pay an annual dividend of $0.65 1 year from now. Analysts expect this dividend to grow at 12% per year thereafter until the fifth year. After then, growth will level off at 2% per year. According to the dividend-discount mode..
|
|
How strategic planning might benefit the organization
: For this Discussion, you consider your vision for a non-profit or government organization and reflect on how strategic planning might benefit the organization
|
|
What do you notice about the source of total energy
: what do you notice about the source of total energy? Using the information in TABLE 1 for 13C, can you offer an explanation for the differences between the age groups in the 13C content of their red blood cells?
|
|
Accounting breakeven point quantity
: Estimate the: a) accounting breakeven point quantity (in terms of inpatient days) and breakeven dollar amount and b) the economic breakeven point quantity (inpatient days) and dollar amount
|
|
Draw a time line to show the cash flows of the project
: Mini-Project 1: Mortgage Loan Analysis: Mr. Johnson plans to buy a new house at Bean Town in September 2014. The sale price of the house is $366,000. He is going to pay 20% down payments and borrow additional 80% from Wells Fargo with a 20-year, 3.87..
|
|
Human resource planning training-assistance program
: The human resource planning process in any organization will no doubt result in the need for recruitment and selection action to be taken.
|
|
Evaluate the nurse recruiting strategy
: How would you evaluate the nurse recruiting strategy currently being used by the hospital? Is the hospital using too few or too many recruiting sources?Why? 2. If you feel the hospital is using too many recruitment sources, which ones would you ..
|
|
Difference between hrm and shrm concpets
: Briefly mention about Virgin/Virgin Atlantic and quote Richard Branson. Briefly discuss the new concept HRM and the missing link to strategy.
|
|
Elements into their environmental management programs
: Name two companies that have incorporated all five elements into their environmental management programs. Describe how these elements have been incorporated
|