Solve the following questions using TVM formulas in Excel. Show your work to receive full credit.1.You own a building that a local business wants to rent for the next 10 years. The business owner has offered to pay $40,000 today or pay $6,400 at the end of each of next 10 years. If your required rate of return is 10%, which payment schedule should you accept?2.How much would you pay to participate in a real estate project that pays nothing for the first 10 years and $2,500 for the following 10 years if you can earn 13% return on other investments of similar risk?3.If your tenant pays you rent of $24,000 a year for 10 years, what is the present value of the series of payments discounted at 10% annually?

1. descriptive statistics quickly describe large amounts of data can predict future stock returns with surprising accuracy statisticians understand non-numeric information, like colors refer mainly to patterns that can be found in data 2. a 15% return on a stock means that 15% of the original purchase price of the stock returns to the seller at the end of the year 15% of the people who purchased the stock will see a return the stock is worth 15% more at the end of the year than at the beginning the stock has lost 15% of its value since it was originally sold 3. a stock purchased on january 1 cost $4.35 per share. the same stock, sold on december 31 of the same year, brought in $4.75 per share. what was the approximate return on this stock? 0.09% 109% 1.09% 9% 4. a stock sells for $6.99 on december 31, providing the seller with a 6% annual return. what was the price of the stock at the beginning of the year? $6.59 $1.16 $7.42 $5.84

Coop inc. owns 40% of chicken inc., both coop and chicken are corporations. chicken pays coop a dividend of $10,000 in the current year. chicken also reports financial accounting earnings of $20,000 for that year. assume coop follows the general rule of accounting for investment in chicken. what is the amount and nature of the book-tax difference to coop associated with the dividend distribution (ignoring the dividends received deduction)?

Type of deposit reserve requirementcheckable deposits $7.8 - 48.3 million 3%over $48.3 million 10noncheckable personal savings and time deposits 0refer to the accompanying table. if a bank has $60 million in savings deposits and $40 million in checkable deposits, then its required reserves are$1.2 million.