Question

In: Accounting

Derick Preuss is considering the purchase of a 2018 Slobiru PZX. After trading in his 2013...

  1. Derick Preuss is considering the purchase of a 2018 Slobiru PZX. After trading in his 2013 Trombona-12 and paying $2,000, he would owe $29,508. Given his 821 FICO score, Chase Finance will finance his car for five years at 3.8%.
    1. What will his monthly payments be? (First, use PMT in Excel; then, solve for A in the PVA equation—cf. the “Calculator_bondvaluation” file I provided).
  1. Use Excel to prepare a Loan Amortization Schedule for the Chase loan. Assume an ordinary annuity. The first payment is due one month after initiation. Make sure to adjust the final payment so as to reach a final balance of zero.

Solutions

Expert Solution


Related Solutions

Bill is single and has the following information for 2018. What is his AGI after considering...
Bill is single and has the following information for 2018. What is his AGI after considering all of this information? Bill is an executive and has $400,000 of salary income. Bill owns 100% of Holtz, Inc. Holtz is a C corporation with $2,000,000 of taxable income for 2018. Bill receives a $75,000 cash dividend. Bill owns 100% of Wallace Enterprises. Wallace is an S corporation. Bill does not materially participate in the S corporation. His basis in the stock is...
James Horner is considering an investment scheme, to fund his house purchase after 6 years, with...
James Horner is considering an investment scheme, to fund his house purchase after 6 years, with following cash deposits for a period of 6 years. Year 1 2 3 4 5 6 Cash deposit ($) 10,000 12,000 14,000 16,000 18,000 20,000 The rate of interest on the deposits is 9% per annum. If James requires an amount of $115,000 at the end of 6 years to purchase the property, how much will be the shortfall or surplus of this investment...
It is now January 1, 2018 and you are considering the purchase of an outstanding bond...
It is now January 1, 2018 and you are considering the purchase of an outstanding bond that was issued on January 1, 2016. It has an 8.5% annual coupon and had a 20-year original maturity. (It matures on December 31, 2035.) There is 5 years of call protection (until December 31, 2020), after which time it can be called at 106 - that is, at 106%. of par, or $1060.00. Interest rates have declined since it was issued, and it...
eBook It is now January 1, 2018, and you are considering the purchase of an outstanding...
eBook It is now January 1, 2018, and you are considering the purchase of an outstanding bond that was issued on January 1, 2016. It has an 8.5% annual coupon and had a 30-year original maturity. (It matures on December 31, 2045.) There is 5 years of call protection (until December 31, 2020), after which time it can be called at 109-that is, at 109% of par, or $1,090. Interest rates have declined since it was issued, and it is...
Investment in Trading Securities The Coca-Cola Company’s December 31, 2013, balance sheet reports investments in trading...
Investment in Trading Securities The Coca-Cola Company’s December 31, 2013, balance sheet reports investments in trading securities at $372 million, with net unrealized gains of $12 million. Required a. How much did Coca-Cola pay for the trading securities reported on its 2013 balance sheet? b. Where are unrealized gains and losses on trading securities reported in Coca-Cola’s nancial statements? c. Assume the trading securities on hand at the end of 2013 were acquired during 2013. Prepare the summary journal entries...
Spring 2018 Quiz 9    Name:_____________ Clyde Corp is considering the purchase of a new piece of...
Spring 2018 Quiz 9    Name:_____________ Clyde Corp is considering the purchase of a new piece of equipment. The cost savings from the equipment would result in an annual increase in cash flow of $100,000. The equipment will have an initial cost of $600,000 and have an 8 year life. The equipment has no salvage value. The hurdle rate is 8%. Ignore income taxes. (Present Value of Annuity for 8%: 5.7466; 12%:4.9676) - Answer the following: a. What is the accounting...
Table 9-10 Product Quantity (2013) Price (2013) Expenditure (2013) Price (2018) Expenditure (on base year quantities)...
Table 9-10 Product Quantity (2013) Price (2013) Expenditure (2013) Price (2018) Expenditure (on base year quantities) (2018) Computers 1 $1,200 $1,200 $900 $900 Books 10 25 250 30 300 Burgers 50    3 150      4 200     Total $1,600 $1,400 38) Refer to Table 9-10. Suppose an economy has only three goods and the typical family purchases the amounts given in the table above. If 2013 is the base year, then what is the CPI for 2018? A) 14.3...
Adam Smith is considering automating his pin factory with the purchase of a $475,000 new machine...
Adam Smith is considering automating his pin factory with the purchase of a $475,000 new machine having a $30,000 salvage value in replacement of the old machine. Shipping and installation would cost $6,000. The old machine was originally purchased for $200,000. It is sold with a market value of $300,000. The old machine has depreciated book value of $150,000 and zero salvage value. The pin factory requires an additional working capital of $80,000. The machine has a useful life of...
Supply manager Joe Smith was considering the purchase of 1,000 desktop PCs for his organization. The...
Supply manager Joe Smith was considering the purchase of 1,000 desktop PCs for his organization. The life cycle was three (3) years and the organization’s cost of capital was 12%. He calculated the TCO for one of the purchase options as follows: Cost Elements Cost Measures Purchase Price: • Equipment Supplier quote: $800 per PC • Software License A Supplier quote: $400 per PC • Software License B Supplier quote: $200 per PC • Software License C Supplier quote: $100...
Jack is considering to purchase a heavy duty grill for his restaurant. Estimated total investment is...
Jack is considering to purchase a heavy duty grill for his restaurant. Estimated total investment is $100,000, and below stream of net cash flow is expected for the next five years. If fair discount rate is 8%, what should be Jack’s decision?              |------------|------------|------------|------------|------------|              0                 1                2                3                4                5 -$100,000       $10,000     20,000      30,000      30,000        30,000 1. If fair discount rate is 8%, what should be Jack’s decision based on the Net Present Value? A. Purchase since NPV is greater than zero B. Do not purchase since NPV is less than...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT