1) The total quality sold is 500 but 20% of your revenue total is service and 80% is sales. Of the sales revenue total, 50% of these sales are on account.

2) On April 1st this week you take out a $50,000 loan to then buy a 3-year bond with a face value of $50,000 and stated rate of 7% which makes interest payments bi-monthly (twice a month). The market rate of interest on April 1st is 7.5%. answer this transaction in excel .

show the accounts and t accounts in excel.