Part (a):It is said that the Indian who sold Manhattan for $33 was a sharp salesman. If he had put his $33 away at5% compounded semiannually, it would now be worth more than $6 billion, and he could buy most of thenow-improved land back! Assume that this seller invested on January 1, 1701, the $33 he received. (Enteramounts in whole dollars, not in billions. Round final answers to nearest whole dollar amount.)Required:1. Use Excel to determine the balance of the investment as of December 31, 2021, assuming a 5% interestrate compounded semiannually. (Hint. Use the FV function in Excel.)2. Use Excel to determine the balance of the investment as of December 31, 2021, assuming an 6% annualinterest rate, compounded semiannually. (Hint. Use the FV function in Excel.)3. What would be the balances for requirements 1 and 2 if interest is compounded quarterly?4. Assume that the account consisting of this investment had a balance of $6.5 billion as of December 31,2021. How much would the total amount be on December 31, 2027, if the annual interest rate is 6%,compounded semiannually?Save & ExitSubmitпетрPart (b):In 2000, a star major-league baseball player signed a 10-year, $261 million contract with the TexasRangers. Assume that equal payments would have been made each year to this individual and that theowners' cost of capital (discount rate) was 9% at the time the contract was signed. What is the presentvalue cost of the contract to the owners as of January 1, 2000, the date the contract was signed, in each ofthe following independent situations? (Use Table 1 and Table 2.) (Round your answers to the nearestwhole dollar amount and not in millions.)Required:1, The player received the first payment on December 31, 2000.2. The player received the first payment on January 1, 2000, the date the contract was signed.3. Assuming the owner is in the 41% income tax bracket, calculate your answer for requirement 1.Complete this question by entering your answers in the tabs below.

Time value of money (TVM) refers to the method used to measure the amount of money at different…

Part (a): It is said that the Indian who sold Manhattan for $33 was a sharp salesman. If he had put his $33 away at 5% compounded semiannually, it would now be worth more than $6 billion, and he could buy most of the now-improved land back! Assume that this seller invested on January 1, 1701, the $33 he received. (Enter amounts in whole dollars, not in billions. Round final answers to nearest whole dollar amount.) Required: 1. Use Excel to determine the balance of the investment as of December 31, 2021, assuming a 5% interest rate compounded semiannually. (Hint. Use the FV function in Excel.) 2. Use Excel to determine the balance of the investment as of December 31, 2021, assuming an 6% annual interest rate, compounded semiannually. (Hint. Use the FV function in Excel.) 3. What would be the balances for requirements 1 and 2 if interest is compounded quarterly? 4. Assume that the account consistino of this inu

Part (a): It is said that the Indian who sold Manhattan for $33 was a sharp salesman. If he had put his $33 away at 5% compounded semiannually, it would now be worth more than $6 billion, and he could buy most of the now-improved land back! Assume that this seller invested on January 1, 1701, the $33 he received. (Enter amounts in whole dollars, not in billions. Round final answers to nearest whole dollar amount.) Required: 1. Use Excel to determine the balance of the investment as of December 31, 2021, assuming a 5% interest rate compounded semiannually. (Hint. Use the FV function in Excel.) 2. Use Excel to determine the balance of the investment as of December 31, 2021, assuming an 6% annual interest rate, compounded semiannually. (Hint. Use the FV function in Excel.) 3. What would be the balances for requirements 1 and 2 if interest is compounded quarterly? 4. Assume that the account consistino of this inu

CONCEPTS IN FED.TAX.,2020-W/ACCESS

20th Edition

ISBN:9780357110362

Author:Murphy

Publisher:Murphy

Chapter11: Property Dispositions

Section: Chapter Questions

Problem 24P

See similar textbooks

Similar questions

3 Charles Company owns a building that originally cost P400,000 and has a current book value of P250,000. Charles Company would like to purchase a new building for P600,000. If the new building is purchased, the existing building would be sold for P380,000. Charles Company’s income tax rate is 40%. If the new building is purchased, the relevant initial cash flows would total: Group of answer choices P292,000 P200,000 P272,000 P328,000 P392,000 P220,000 P372,000 P600,000
Solve the following: 2. In purchasing of house, a man makes P720,000 down payment and agrees to pay P1,200,000 5 years later. Find the cash value of the house if money is worth 14% compounded semi-annually. 3. How much must a corporation deposit in a bank which credits interest at 12% compounded monthly to come up in 8 years with P2,500,000 needed for its expansion program? 4. On the birth of a child, a father wished to invest in a trust fund which gives 12% compounded quarterly. How much must he invest if he wants to accumulate P650,000 by the time the child reaches his 21st birthday? 5. To provide for a purchase of a car worth P950,000 as a gift to his mother 5 years from now. How much should Benjamin invest today at 18% compounded quarterly? 6. Mrs. Dela Cruz invested P70,000 at 12% compounded quarterly for 5 years and another P70,000 at 18% compounded semi-annually for the same length of time. Find the total amount of the two investments. 7. Four friends deposited…
2. An equipment was purchased for P100,000 cash and the balance will bepaid at the end of each quarter for 5 years at P20,000. However, thepurchaser failed to pay the first 5 payments of P20,000 each. At the end ofthe 6th quarter, the purchaser desires to pay the equipment by a singlepayment which will cancel his accumulated and future liabilities. What musthe pay if money is worth 6% per annum?
Suppose Hampton Corporation sells land for $8,000,000. Hampton paid $5,000,000 for the land several years ago. Assuming a marginal tax rate of 34%, calculate the after-tax cash flow resulting from the land sale.
You can buy property today for $2.1 million and sell it in 6 years for $3.1 million. (You earn no rental income on the property.) a. If the interest rate is 11%, what is the present value of the sales price? (Do not round intermediate calculations. Enter your answer in millions rounded to 3 decimal places.) b. Is the property investment attractive to you? c-1. What is the present value of the future cash flows, if you also could earn $110,000 per year rent on the property? The rent is paid at the end of each year. (Do not round intermediate calculations. Enter your answer in millions rounded to 3 decimal places.) c-2. Is the property investment attractive to you now?
a investor purchased a 91 day, $100,000.00 t-bill on its issue date fir $99, 441.89, after holding it for 16 days, she sold the t bill for a yeild of 2.21% what is the original yeild of the t bill? what was the t bill sold for? the investor realized the rate of return was?
Brendan & Kelly purchased an item valued at $147,000. They paid $22,050 down and financed the rest at 2.8% compounded annually. To reduce the amount owing to $32,490 at the end of 3 years, what size of equal payments must Brendan & Kelly make at the end of each three months? Enter the present value as a positive value in the PV box below. Enter PMT and FV as positive or negative values based on PV being positive. Report PMT accurate to the nearest cent. P/Y = C/Y = N = I/Y = PV = PMT = FV= The size of each equal payment is (enter a positive value) $ .__________________
An investor has owned a property for five years. A property could be sold today for $2 million. It has a loan balance of $ 1 million and, if sold, the investor would incur a total of $250,000 in taxes (capital gains tax + depreciation recapture tax). The investor has determined that if it were sold today, she would have earned an IRR of 15% on equity for the past five years. If not sold, the property is expected to produce after tax cash flow of $50,000 over the next two years. At the end of the two years, the property value is expected to increase to $2.1 million, the loan balance will decrease to $900,000. If sold after two years, the investor would incur a total of $255,000 in taxes. A. What is the incremental internal rate of return for keeping the property two additional years? B. The investor has an outside investment opportunity that is expected to earn him a rate of return of 15%. What advice would you give the investor?
2. The Jones Company has just completed the third year of a five-year MACRS recovery period for a piece of equipment it originally purchased for $302,000. a. What is the book value of the equipment? b. If Jones sells the equipment today for $184,000and its tax rate is 21%, what is the after-tax cash flow from selling it? Note: Assume that the equipment is put into use in year 1. a. What is the book value of the equipment? The book value of the equipment after the third year is $____ (Round to the nearest dollar.) b. If Jones sells the equipment today for $184,000 and its tax rate is 21%, What is the after-tax cash flow from selling it? The total after-tax proceeds from the sale will be $____ (Round to the nearest dollar.)
A pair of twins were given $20,000 on their birthday in 2020. One twin purchased a car for $20,000 with a expected life of 7 years and residual value of $3,000. The other twin bought one Bitcoin. Assume straight line depreciation. If Bitcoin is now worth $60,000, how much is the difference between the book value of twin 1's car and the twin 2's bitcoin? Hint: $60,000-book value. Assume this is the end of year two for the car.
You can buy property today for $3.1 million and sell it in 6 years for $4.1 million. (You earn no rental income on the property.) a. If the interest rate is 7%, what is the present value of the sales price? (Do not round intermediate calculations. Enter your answer in millions rounded to 3 decimal places.) b. Is the property investment attractive to you? yes or no c-1. What is the present value of the future cash flows, if you also could earn $210,000 per year rent on the property? The rent is paid at the end of each year. (Do not round intermediate calculations. Enter your answer in millions rounded to 3 decimal places.) c-2. Is the property investment attractive to you now? yes or no
Supposed amarriedcouple wishesto acquire aluxurious condominium in Tagaytay.Thiscan be acquired by a downpayment of P700,000and a yearly payment of P150,000 at the end of each year for a period of 10 years, starting at the end of 5 years from the date of purchase. If money is worth 15% compounded annually, what is the cash price of the property?