Assume that you are about to sell property (a vacant parcel of real estate) you own but otherwise have no use for. The net-of-sales-commission selling price for the property is $500,000. You are willing to finance this transaction over a 20-year period and have told the buyer that you expect a 12% pretax return on the transaction. The buyer has asked you for a payment schedule under several alternatives. Required: 1. What will be your periodic cash receipt, to earn a 12% return, if payments are received from the purchaser: NOTE: to answer the above questions, use the PMT function in Excel, as follows: PMT(rate, nper, pv, fv, type) where: rate is the interest rate for the loan, nper is the total number of payments, pv is the present value (i. e., the total amount that a series of future payments is worth now; also known as the principal), fv is the future value (or a cash balance you want to attain after the last payment is made; if fv is omitted, it is assumed to be 0 (zero)), and type is the number 0 (zero) or 1 and indicates when payments are due (if omitted, or 1 is chosen, it is assumed that payments occur at the end of each period). Additionally, what is the total of cash receipts over a 20-year period for each of the four situations

During january 2018, the following transactions occur: january 1 purchase equipment for $20,600. the company estimates a residual value of $2,600 and a five-year service life. january 4 pay cash on accounts payable, $10,600. january 8 purchase additional inventory on account, $93,900. january 15 receive cash on accounts receivable, $23,100 january 19 pay cash for salaries, $30,900. january 28 pay cash for january utilities, $17,600. january 30 firework sales for january total $231,000. all of these sales are on account. the cost of the units sold is $120,500. the following information is available on january 31, 2018. depreciation on the equipment for the month of january is calculated using the straight-line method. the company estimates future uncollectible accounts. at the end of january, considering the total ending balance of the accounts receivable account as shown on the general ledger tab, $4,100 is now past due (older than 90 days), while the remainder of the balance is current (less than 90 days old). the company estimates that 50% of the past due balance will be uncollectible and only 3% of the current balance will become uncollectible. record the estimated bad debt expense. accrued interest revenue on notes receivable for january. unpaid salaries at the end of january are $33,700. accrued income taxes at the end of january are $10,100