Preface: Suppose Beyoncé and Jay-Z want to purchase a home that costs $88 million, but they are willing to pay $100 million for the house. They plan on keeping the home for 1 year and selling it. Jay-Z and Beyoncé have $88 million in a brokerage account invested in the stock market that has an expected return of 10% over the course of the next year. Wells Fargo will give them a $88 million mortgage at a 4% fixed interest rate with no money down. The mortgage is only for 1 year and the interest and principal payments are due at the end of the year. Assume there are no tax benefits associated with the mortgage.
Instructions:
Using the information in the preface, fill in the blank information throughout the following steps of the economic decision making process to ascertain whether Beyoncé and Jay-Z should take out an $88 million mortgage for 1 year, or whether they should pay the house off and have no mortgage.

Gideon company uses the allowance method of accounting for uncollectible accounts. on may 3, the gideon company wrote off the $2,200 uncollectible account of its customer, a. hopkins. on july 10, gideon received a check for the full amount of $2,200 from hopkins. the entry or entries gideon makes to record the write off of the account on may 3 is:

The county collector of suncoast county is responsible for collecting all property taxes levied by funds and governments within the boundaries of the county. to reimburse the county for estimated administrative expenses of operating the tax agency fund, the agency fund deducts 1.5 percent from the collections for the town, the school district, and the other towns. the total amount deducted is added to the collections for the county and remitted to the suncoast county general fund.the following events occurred in 2017: 1. current-year tax levies to be collected by the agency were: county general fund $ 10,333,000 town of bayshore general fund 4,840,000 suncoast county consolidated school district 6,550,000 other towns 3,120,000 total $ 24,843,000 2. $13,700,000 of current taxes was collected during the first half of 2017.3. liabilities to all funds and governments as a result of the first half-year collections were recorded. (a schedule of amounts collected for each participant, showing the amount withheld for the county general fund and net amounts due the participants, is recommended for determining amounts to be recorded for this transaction.)4. all cash in the tax agency fund was distributed.requireda. prepare journal entries for each of the foregoing transactions that affected the tax agency fund. (if no entry is required for a transaction/event, select "no journal entry required" in the first account field. do not round intermediate calculations. round your answers to the nearest whole dollar amount.)1. record the current-year tax levies to be collected by the agency.2.record the current taxes collected during the first half of 2017.3.record the liabilities due to all funds and governments at the end of first half-year.4. record the distribution of all cash in the tax agency fundb. prepare journal entries for each of the foregoing entries that affected the town of bayshore general fund. begin with the tax levy entry, assuming 2 percent of the gross levy will be uncollectible. (if no entry is required for a transaction/event, select "no journal entry required" in the first account field. do not round intermediate calculations. round your answers to the nearest whole dollar amount.)1.record the revenues receivable and uncollectible.2. record the taxes collected

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?