Reference no: EM13881922
Lucinda Lacy purchased a foreclosed house today for $105,500 by making a down payment of 15% of the purchase price and paying closing costs of:
Loan origination fee 1.7% of purchase price
Appraisal fee $325
Survey fee 210
Attorney’s fee 420
Processing fee 300
Escrow fee 240
Other miscellaneous costs 620
Lucinda has a mortgage loan with an interest rate of 3.9% APR, compounded monthly for 30 years. Her taxes and insurance are $375 per month. Lucinda has an estimate for a contract for $8,500 firm, fixed price to remodel the house and this expense will be equally distributed over the period of her ownership. After remodelling, she estimates that she could sell the house for $135,000. Her selling expenses would be 7% sales commission plus $1000.
Assignment
1. Determine manually (handwritten), by trial and error, Lucinda’s rate of return, if she owns the house for 6 months.
Note: To get full credit, you must show the manual (handwritten), calculations, including the ball-park method with all the appropriate cash flow diagrams.
2. Prepare a typed Amortization chart that how much would be owed at the end of each month for six months and the amount of the payoff value.
3. Prepare an EXCEL spreadsheet to determine Lucinda’s rate of return if she owns the house for 6 months (comparable to number 1).
4. Use the spreadsheet to determine the ROR if Lucinda keeps the house for 6 months and the selling price is $132,500 instead of $135,000.
5. Use the spreadsheet to determine the ROR if the sales price is $131,500 and the repairs take longer than expected and Lucinda keeps the house for 12 months before selling and the remodeling contract is for 12 months instead of 6.
|
Spend all of its excess cash on share repurchase program
: A firm has a market value equal to its book value. Currently, the firm has excess cash of $1,400 and other assets of $3,500. Equity is worth $4,900. The firm has 700 shares of stock outstanding and net income of $1,450. The firm has decided to spend ..
|
|
Market risk of project is its degree of operating leverage
: One factor that can affect the market risk of a project is its degree of operating leverage, which is
|
|
A firm has market value equal to its book value
: A firm has a market value equal to its book value. Currently, the firm has excess cash of $700 and other assets of $7,000. Equity is worth $7,700. The firm has 550 shares of stock outstanding and net income of $900. What will the new earnings per sha..
|
|
What is the value of the embedded call option
: Assume that the 3-year 4.5% bond is callable in Year 1 at (101) and in Year 2 at par. The call rule is to call whenever the price exceeds the call price. Calculate the value of the bond with the embedded option. What is the value of the embedded call..
|
|
Purchased foreclosed house-mortgage loan with interest rate
: Lucinda Lacy purchased a foreclosed house today for $105,500 by making a down payment of 15% of the purchase price and paying closing costs of: Determine manually (handwritten), by trial and error, Lucinda’s rate of return, if she owns the house for ..
|
|
Impact of sub cultural elements such income-social class
: What is the impact of sub cultural elements such as income, social class, religion, ethnicity, gender, and age on consumer buying? How do these affect consumer shopping behavior? What sub cultural elements best influence online versus mall shopping p..
|
|
What is the current total value of beach and company assets
: Beach & Company reported net income of $40 million for last year. Depreciation expense totaled $18 million and capital expenditures came to $8 million. Free cash flow is expected to grow at a rate of 5% for the foreseeable future. What is the current..
|
|
Under the traditional job order costing system
: Overhead is applied on the basis of machine hours. It takes 3 machine hours to produce a large doll house and 2 machine hours to produce a small doll house. EDHC produces 2,000 large doll houses and 10,000 small doll houses in a year. Total manufactu..
|
|
What is the annual percentage yield for money
: What is the purchase price of a 39-week “T-bill” (US Treasury note) with a maturity value of $4500 that earns an annual interest rate of 3.25 % ? How long (in years) will it take $1000 to triple if it is invested at 7.0% compounded continuously? Roun..
|