Marc and Michelle are married and earned salaries this year of $64,000 and $12,000, respectively. In addition to their salaries, they received interest of $350 from municipal bonds and $500 from corporate bonds. Marc contributed $2,500 to an individual retirement account, and Marc paid alimony to a prior spouse in the amount of $1,500 (under a divorce decree effective June 1, 2005). Marc and Michelle have a 10-year-old son, Matthew, who lived with them throughout the entire year. Thus, Marc and Michelle are allowed to claim a $1,000 child tax credit for Matthew. Marc and Michelle paid $6,000 of expenditures that qualify as itemized deductions and they had a total of $5,500 in federal income taxes withheld from their paychecks during the course of the year. (use the 2016 tax rate schedules). 1. What is the total amount of Marc and Michelle’s deductions from AGI?
2. What is Marc and Michelle’s taxable income?
3. What is Marc and Michelle’s taxable income?

In a sumif conditional function, what should be the order of terms in the parentheses?

Seattle bank’s start-up division establishes new branch banks. each branch opens with three tellers. total teller cost per branch is $96,000 per year. the three tellers combined can process up to 90,000 customer transactions per year. if a branch does not attain a volume of at least 60,000 transactions during its first year of operations, it is closed. if the demand for services exceeds 90,000 transactions, an additional teller is hired and the branch is transferred from the start-up division to regular operations. required what is the relevant range of activity for new branch banks

Lo.2, 3, 9 lori, who is single, purchased 5-years class property for $200,00 and 7-years class property for $420,000 on may 20, 2018. lori experts the taxable income derived form the business (without regard to the amount expensed under ⧠179) to be about $550,000. lori has determined that she should elect immediate ⧠179 expensing in the amount of $520,000, but she doesn’t know which asset she should completely expense under ⧠179. she does not claim any available additional first-year depreciation. a. determine lori’s total cost recovery deduction if the ⧠179 expense is first taken with respect to the 5-year class asset. b. determine lori’s total cost recovery deduction if the ⧠179 expense is first taken with respect to the 7-year class asset. c. what is your advice for lori? d. assume that lori is in the 24% marginal tax bracket and that she uses ⧠179 on the 7-year asset. determine the present value of the tax savings from the depreciation deductions for both assets. see appendix g for present value factors, and assume a 6% discount rate. e. assume the same facts as in part (d), except that lori decides not to use ⧠179 on either asset. determine the present value of the tax savings under this choice. in addition, determine which option lori should choose. f. present your solution to parts (d) and (e) of the problem in a spreadsheet using appropriate microsoft excel formulas. e-mail your spreadsheet to your instructor with a two-paragraph summary of your findings.