1 Page

Chapter 9 Spreadsheet for Students

Course: ACCT210 ACCT210, Spring 2012
School: S. Alberta Tech
Rating:
 
 
 
 
 

Word Count: 493

Document Preview

w/o 52-AGI exp. Moving Exp. AGI 120,000 -4,000 FOR AGI 116,000 MID: Auto. Exp. Enter. @ 50% Travel w/o meals Meals @ 50% Dues Total MID 2% floor 2,500 750 2,000 250 500 6,000 -2,320 3,680 FROM AGI 53-Air and Lodging Travel Meals @50% Transportation Enter. @ 50% Total FOR AGI 4,000 500 2,000 1,000 7,500 self-employed c. Now they are FROM AGI and MID, subject to 2% floor 54-- FROM AGI Airfare Taxi Travel...

Register Now

Unformatted Document Excerpt

Coursehero >> Canada >> S. Alberta Tech >> ACCT210 ACCT210

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
w/o 52-AGI exp. Moving Exp. AGI 120,000 -4,000 FOR AGI 116,000 MID: Auto. Exp. Enter. @ 50% Travel w/o meals Meals @ 50% Dues Total MID 2% floor 2,500 750 2,000 250 500 6,000 -2,320 3,680 FROM AGI 53-Air and Lodging Travel Meals @50% Transportation Enter. @ 50% Total FOR AGI 4,000 500 2,000 1,000 7,500 self-employed c. Now they are FROM AGI and MID, subject to 2% floor 54-- FROM AGI Airfare Taxi Travel Meals @50% Laundry away from home Lodging Bus. Meals @50% Enter. @ 50% Invest. Exp. Tax return. Prep. 1,500 100 150 50 650 250 250 1,000 500 4,450 -1,400 3,050 From AGI Less 2% floor Total MID 55- Away from home for less than one year Airfare Airfare Apartment Rent Meals @ 50% Enter. @ 50% Total MID Less: 2% floor 800 8,000 10,000 4,250 1,000 24050 -2,400 21650 FROM AGI, MID d. Yes, now they are personal expenses and not deductible because she is not away from home e. potentially only the expenses for 10 months would be deductible 56-- a. air meals hotel enter. 450 150 300 500 1400 (50X3) (100X3) fully reimbursed expenses are FOR AGI, but the reimbutsement is not shown on the return so the expenses are not shown b c. 57-- 5,000 - 3,000 = 2,000 Unreimbursed expenses 3,000/5,000 = 60% Reimbursed 2,000/5000 = 40% Unreimbursed Dues Air and Lodging Transportation Enter. @ 50% Total FOR (60%) 600 1,200 600 600 3,000 From (40%) 400 800 400 200 400@50% 1,800 other deductions c. 1,000 2,000 1,000 1,000 1,000 2,800 now there would be a 1,000 of income to be reported unless she returns the amount 58-a. and b. AGI w/o exp. Moving AGI ID: Mortgage Int. Prop. Tax MID: Safe Deposit Tax Ret. Prep. Unreimbursed. Unreim. Meals Total 2% Floor MID Total ID PE Taxable Income 100,000 -2,000 FOR AGI 98,000 12,000 1,800 50% 100 500 6000 600 7200 -1960 5,240 c. ID: Mortgage Int. Prop. Tax MID: Safe Deposit Tax Ret. Prep. Unreimbursed. Unreim. Meals Total 2% Floor MID Total ID 59-a. & b. c. 60-a. 5,000 MID, subject to 2% floor 5,000 FOR AGI (not subject to 2% floor) 24,000 x .50 Parkings & Tolls Reimburse. b. Total Parking Expenses Less: and Tolls Bus. Usage 12,000 100 11,900 9,600 (24,000 x .40) 2,300 MID subject to 2% floor 20,400 40,000*.51 100 20,500 -16,000 40,000*.40 4,500 16,500 100 16,400 x .60 9,840 Parking and Tolls Reimburse. MID subject to 2% floor c. 61-Dues Business lunches Entertain. @ 50% Entertain. @ 50% 62-Football tickets Skybox Total 63-a. 1,000 0 1,000 750 2,750 FOR AGI 3,600 face value 7,200 (20 x $60 x 6) 10,800 x 50% 5,400 11,250 Reimbursement: Latrisha does not report the reimbursement or deduct the expenses on her return. Company would get a deduction of 5,850 + 1,800 + 600 + 1,200 = 9,450 9,000 Reimbursement: 11,250 - 9,000 = 2,250 Unreimbursed 9,000/11,250 = 80% reimbursed 2,250/11,250 = 20% unreimbused Air Lodging Meals Enter. FROM AGI 20% FOR AGI 80% 5,850 1,170 4,680 1,800 360 1,440 1,200 120 960 2,400 240 1,920 11,250 MID, subject to 2% floor 9,000 1,890 Company would get a deduction of 4,680 + 1,440 + 480 + 960 = 7,560 14,000 Reimbursement: b. Air Lodging Meals Enter. MID, subject to 2% Floor 64-Direct Moving expenses Auto Moving Van Total Moving FOR AGI c. 65-a. b. c. d. e. 72-a. b. c. d. 62,000 - 56,000 = 6,000/10,000 = 60% phase out 5,000 X 40% = 2,000 IRA deductible FOR AGI in 2010 57,000 - 56,000 = 1,000/10,000 = 10% phase out 5,000 X 90% = 4,500 IRA for 2011 FOR AGI 50,000 in either 2010 or 2011 5,000 IRA, plus another 5,000 for a spousal IRA 73-a. b. c. d. e. f. 10,000 2011 FOR AGI still 10,000 because they did not have AGI of 90,000 yes however it cannot total more tan 5,000 phil cannot deduct any ira but his wife can have a spousal ira of 5,000 74-a. Roth not eligble for a traditional because her income exceeds 66,000 111,000 - 105,000 = 6,000/15,000 = 40% phase out 113,000 - 107,000 = 6,000/15,000 = 40% phase out 5,000 X 60% = 3,000 Roth IRA b. 2,000 X 6 years = 12,000 15,000-12,000=3,000 would be taxable as income and subject to 10% penalty for early withdrawal House: non taxable c. in 2011 and after she can do this andpay tax on the rollover
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

S. Alberta Tech - ACCT210 - ACCT210
47-Angela has no self employment income and therefore no self employment taxArnie:2010201140,00040,00035,00035,00075,00075,000x.9235x.923569262.569262.5x .153x .13357.51% for 201110597.1625 9211.9125 (will also receive 1/2 of SE tax as a
S. Alberta Tech - ACCT210 - ACCT210
ETHICAL DILEMMA #1 DUE SEPTEMBER 7The roof of your office building recently experienced some damage as the result of a storm. Youare negotiating with a carpenter who has quoted two prices for the repair work: $600 if you payin cash (folding money) and
S. Alberta Tech - ACCT210 - ACCT210
Jordan EvansETHICAL DILEMMA #2 DUE OCTOBER 17Clyde owns a trucking firm that operates in the Mid-Atlantic states. One of his major customersfrequently ships goods between Charlotte and Baltimore. Occasionally, the customer sends lastminute shipments th
S. Alberta Tech - ACCT210 - ACCT210
Jordan EvansETHICAL DILEMMA #3 DUE NOVEMBER 15Theft losses of personal use assets are itemized deductions in the year of discovery. Thetaxpayer must show that the property was actually stolen. Losses due to mislaying or losingproperty cannot be deduct
S. Alberta Tech - ACCT210 - ACCT210
1ETHICS IN ACCOUNTING AND BUSINESSPray for us. We are sure that we have a clear conscience and desire to livehonorably in every way. Hebrews 13:18Ethics are the standards of conduct by which ones actions are judged as right orwrong, honest or dishone
S. Alberta Tech - ACCT210 - ACCT210
1Tax (ACCT 3413) Homework AssignmentsDateChapterAssignmentAug. 301OrientationSept. 112*, 5*, 10*, 29, 30, 34324*, 5*, 10*, 29; Read pp. 2-76214*, 17*, 18*, 30, 33, 34; Read pp. 8-168237, 39, 40, 42; ED #1; Read pp. 17-2410244, 46, 47
S. Alberta Tech - ACCT210 - ACCT210
Jordan Evans1abc10 aba taxpayers themselves, their spouses or theirdependent if qualified for a depencency exemption orqualified children of divorced parentsno just as long as one parent claims the child as adependent then the parent who pays t
S. Alberta Tech - ACCT210 - ACCT210
60-TaxableIncome:WagesWagesCapitalGains(12,5008,600)CapitalLosses(5,2007,900)AGIID:MedicalEyeSurgeryMed Ins.Prem.150,0003,8883,900-2,700155,0883,0001,9004,9007.5% xAGITotalMedStateIncomeTaxWithheldWithheldPaid in2010 for
S. Alberta Tech - ACCT210 - ACCT210
5.34a.b.c.BasisLandBuildingSame for both30,00090,00090,0005.35a.b.490,000 Gain5.43a.28%280017,55626,68844,244 TAXb.c.collectibles tax 10,000 @28%44,2442,80047,044200,000-137,300190,000-137,300=62,700 @ 28%=52,700
S. Alberta Tech - ACCT210 - ACCT210
Jordan EvansTax 1 HW12,5,1029,30,342. Why was pay-as-you-go withholding needed in 1943?To accommodate the broadened tax base and to avoid significant tax collection problems,5. Carmen has computed that her average tax rate is 16% and her marginal ta
S. Alberta Tech - ACCT210 - ACCT210
2.4Jordan EvansAll dependents must:Have a qualifying identification numberEveryone must have a Social Security numbermeet a citizenship restmust be US citizens or nationals, or residents of the U.S., Canada, or Mexico for somepart of the yearmeet
S. Alberta Tech - ACCT210 - ACCT210
Jordan Evans2.14purpose of a multiple support agreementit is the agreement that must be reached among multiple people that support the same person.It is the agreement on who out of the group gets to claim the dependent on their taxes2.17explain what
S. Alberta Tech - ACCT210 - ACCT210
Jordan EvansJordan Evans3.4means that tax should be collected when the taxpayer is in thebest position to pay.3.12the income is made available to the taxpayer so that he maydraw ypon it at any time. This rule prevents taxpayers fromdefering income
S. Alberta Tech - ACCT210 - ACCT210
Jordan Evans4.4 2 reasonssicial policyreasons of incentive4.10 aa scholarship is an amount paid or allowed to astudent whether an undergraduate or graduate to aiddegree-seeking individualsbyes because it is covering living expensescnodYes it
S. Alberta Tech - ACCT210 - ACCT210
4.33 a)b)c)33, 34, 39, 40;No, cannot charge yourselfYes, you would have an expenseand benefit that would cancel eachother out200 for each taxpayerNo, is probably a gift4.34 a)b)c)YesYesNo, probably a gift4.39 a)b)c)YesYesYes4.40 a)b
S. Alberta Tech - ACCT210 - ACCT210
Jordan Evans6.1 FOR agi deductions subtracted from gross income in order to calculate your AGIFROM agi deductions subtracted from AGI to calculate taxable income6.2 FOR agi6.7 No it wouldn't it might be determined by the amount of the occasional profi
S. Alberta Tech - ACCT210 - ACCT210
Jordan Evans5.44LTCGLTCGLTCLAabcB15,0007,000-3,00019,000LTCGTaxed @ 15%2,850LTCGSTCGLTCLLTCGSTCGSTCGLTCG15,000-3,00012,0007,0007,000@35%12,000@15%CLTCGLTCGLTCL15,000-3,00012,000Collectible 7,000@28%LTCG12,000@15%5.4
S. Alberta Tech - ACCT210 - ACCT210
Jordan Evans5.44LTCGaLTCGbLTCLcAB15,0007,000-3,00019,000LTCGSTCGLTCLLTCGSTCGSTCGLTCGLTCGTaxed @ 15%2,8505.45 AC15,000--3,00012,0007,0007,000@35% 2,45012,000@15% 1,800LTCGLTCGLTCL15,000-3,00012,000CollectibleLTCG7,0
S. Alberta Tech - ACCT210 - ACCT210
Jordan Evans5.4sharesvaluevalue per shareshare 1share 2totalsoldtotal100100200501509,00012,00021,0008,00013,0009012010516087Gain per share160 - 105 = 5550*5582,500/50016550 * 1658,2505.75.15record it as a nonbusiness bad
S. Alberta Tech - ACCT210 - ACCT210
Jordan Evans8.3 describe usual tax consequences that apply to a worthless security.you can take deductions on the securities8.7 section 1244 stockcan deduct loss or gains on the stock. For individuals thetax law provides an excetion on losses from sa
S. Alberta Tech - ACCT210 - ACCT210
Jordan Evans9.1why does employee or self-employed matter?self-employed deductions are FOR agiemployees can either deduct FOR or FROM agi9.3for, from, or nondeductibleA.B.C.D.E.F.G.Nondeductible because it was reimbursed 50% applied if unreim
S. Alberta Tech - ACCT210 - ACCT210
Jordan EvansEntertainment expenses are not considered "directly related" if there are9.17 substantial distractions.for several reasons and mainly to avoid people taking advantage ofentertainment expense deductyions. Congress enacted sec. 274 which is
S. Alberta Tech - ACCT210 - ACCT210
ch 848, 52, 53, 54;48-LossBusinessEquip. APart. DestroyedIns. Proc.(8,300)3,700(Decline in FMV 12,300 - 4,000)(4,600) lossEquip. BFully DestroyedIns. Proc.Equip. C?Ins. Proc.Del. Truck(basis)Fully DestroyedIns. Proc.(3,000)7,8004,80
S. Alberta Tech - ACCT210 - ACCT210
12.40abcd12.32410,000realized gainrecognized gain0basis for the building received540,000840,00012/31/2012 two years after the close of the first taxable yearnodefer the gain but the new basis for the tank is 570,000yes12-31-2013 like kind
S. Alberta Tech - ACCT210 - ACCT210
65,000 what I receive10,00065,000 what I received20,000 boot/realized gain-50,000 basis25,000 realized gain100,000 what I received2,000 boot/realized gain-70,000 basis15,000 real gain10,000 recognized gain-70,000 basis32,000 real gain15,000 r
S. Alberta Tech - ACCT210 - ACCT210
what I receive65,00010,000basis65,00020,000-50,00025,000 realized gain10,000basis of old property-boot received+gain recognized= new basis-70,00015,00015,000100,000 what I received2,000 boot/realized gain-70,000 basis32,000 real gain2,
S. Alberta Tech - ACCT210 - ACCT210
1Special Homework #1A.During the year, Martin rented his vacation home for three months and spent one month therepersonally. Gross rental income from the property was $5,000. Martin incurred the followingexpenses, mortgage interest of $3,000, real es
S. Alberta Tech - ACCT210 - ACCT210
Jordan EvansTax project #31) IRC 112CERTAIN COMBAT ZONE COMPENSATION OF MEMBERS OF THE ARMED FORCES112(a) Enlisted Personnel.Gross income does not include compensation received for active service as a member below thegrade of commissioned officer in
S. Alberta Tech - ACCT210 - ACCT210
Jordan EvansTax project #31)IRC 102GIFTS AND INHERITANCES.102(a) General Rule .Gross income does not include the value of property acquired by gift, bequest, devise, or inheritance.102(b) Income .Subsection (a) shall not exclude from gross income
S. Alberta Tech - ACCT210 - ACCT210
business casualty loss reduces AGIFOR AGI know how to determine the loss for FD and PDmoving expenses reduce AGIFOR AGI know what constitutes moving expenses and whattraditional IRA reduces AGIFOR AGItraditional is lesser of 100 % of compensation or
CUNY City - CHEM - 263
Name: Bivas SarkerID Number : *0959Title: Extraction of Benzoic Acid and AcetanilideAim of the experiment: The aim for this experiment is to explain the process ofextraction by extracting benzoic acid and acetanilide from dichloromethane.Table of phy
UCLA - ECON - 203c
UCLA - ECON - 203c
Economics 203CIntroduction to EconometricsSystem ModelsSpring, 2008Moshe BuchinskyDepartment of EconomicsUCLAEconomics 203Introduction to Econometrics: System ModelsFinal ExaminationJune 11, 2008This is a 3 hour open-book exam. You are allowed t
UCLA - ECON - 203c
ECON 203C: System ModelsFinal 2008 Suggested AnswersHisayuki YoshimotoLast Modied: June 14, 20081Question 4 (40 points)Consider the binary model given by the following latent variableyi = x0 + "iifor i = 1; : : : ; nwhere0="i j xi[1; 2 ; : :
UCLA - ECON - 203c
ECON 203C: System ModelsTA Note 6: Version 1Hypothesis Tests of ML and GMM EstimationsHisayuki YoshimotoLast Modied: May 20, 2008Abstract:1Wald, Lagrange Multiplier (LM), and Likelihood Ratio (LR) Statistics1.1Review of ML and GMM estimatorNNA
UCLA - ECON - 203c
ECON 203C: System ModelsTA Note 4: Version 3Binary Choice (Probit and Logit) ModelsHisayuki YoshimotoLast Modied: May 7, 2008Abstract: In section 1, we review Bernoulli random variable that is basis of binary choice model. In section 2, wesolve Fina
UCLA - ECON - 203c
Econ 203c, Spring 2003, Final ExamQuestion 1y i x i z u iiz 1i z v 1iiz 2i z v 2iiAssume: Eu i |x i , z covu i , v 1i covu i , v 2i 0 and covv 1i , v 2i 0iNote: There was a typo that was not corrected during the exam: covv 1i , v 2i 0. Iwill be
UCLA - ECON - 203c
UCLA - ECON - 203c
Korea University - ECON - 205
DF (x )(y x ) = 0. However,F (1 t )x + t y) F (x )t 0t(1 t )F (x ) + tF (y) F (x ) limt 0t= F (y) F (x ) > 0,g (0) = lima contrdiction.17.3 Calculus Criteria for Concavity (21.1)Theorem 63 (Thm 21.3(p.511) and Thm 21.5(p.513). Let F : U R1 be
Korea University - ECON - 205
Mathematics for Economists1 Introduction1.1 Motivation Why do we need to know mathematics in order to learn economics? What is economics? In economics we learn how the economy works in various situations. An economy consists of various people (consu
Korea University - ECON - 205
2.7 Differentiability and Continuity A function f is differentiable at x0 if the following limit existslimh0f (x0 + h) f (x0 ).h A function f is continuous at x0 if limh0 f (x0 + h) exists and limh0 f (x0 +h) = f (x0 ).Example 1 (Non-differentiab
Korea University - ECON - 205
4.2 Inverse FunctionsDenition 4 (p.76). For a given function f : E1 R1 , E1 R1 , we say a functiong : E2 R1 , E2 R1 , is an inverse of f ifg( f (x) = x for all x E1 andf (g(y) = y for all y E2 .1 Example: f (x) = 3 2x, g(y) = 2 (3 y) If f has an in
Korea University - ECON - 205
6 Integration (A.4)6.1 Indenite Integral Consider a continuous function f (x), where f (x) > 0 for all x. Consider the area under the graph of y = f (x) from a certain point a to anotherpoint x and denote it by A(x; a). What is the derivative of A(x;
Korea University - ECON - 205
9 Limits and Open Sets (ch.12)9.1 Sequences in Real NumbersA sequence of real numbers cfw_x1 , x2 , , xn , is an assignment of a real number xnto each natural number n.Denition 7 (p.255). Let cfw_x1 , x2 , , xn , be a sequence of real numbers. A rea
Korea University - ECON - 205
Theorem 34 (Thm 13.3, p.291). The general quadratic form Q(x1 , , xk ) = i j ai j xi x jcan be written as1a11 2 a12 1 a1kx12 1 a12 a22 1 a2k x2 22x1 x2 xk ... . ,.... . .....11xkakk2 a1 k2 a2 k or xT Ax, where A is a symmetric m
Korea University - ECON - 205
12 Calculus of Several Variables (ch.14)12.1 Partial DerivativeDenition 25 (p.300). Let F : Rk R. The partial derivative of f with respect to xi atx0 = (x0 , , x0 ) is dened as1kF (x0 , , x0 + h, , x0 ) F (x0 , , x0 , , x0 )F 0ii11kk(x ) = l
Korea University - ECON - 205
Theorem 41 (Thm 30.5, p.828). Let f : R1 R1 be a C2 function. For any point a <b R1 , there is a point c (a, b) such that f (b) = f (a) + f (a)(b a) + 1 f (c)(b 2a)2 .Proof. Dene2f (b) f (a) f (a)(b a) .(b a)2Suppose that f (x) = M for all x (a, b
Korea University - ECON - 205
Example 6. Suppose that we have a production function Q = kxa yb . Then,Q= akxa1 yb ,x 2Q= abkxa1 yb1 , x yQ= bkxa yb1y 2Q= abkxa1 yb1 y x14 Some Linear Algebra14.1 Deniteness of Quadratic Forms (16.2)Denition 27. Let A be an m m symmetric
Korea University - ECON - 205
Theorem 53 (Thm 11.2, p.243). Let A = (a1 , a2 , , am). If a1 , a2 , , am are linearlyindependent if and only if det A = 0.Proof. a) only if: If a1 , a2 , , am are linearly independent, then A is one-to-one andonto, hence has an inverse function. Call
Korea University - ECON - 205
Denition 36 (p.161). An m m matrix A = (ai j ) is called an upper-triangular matrixif ai j = 0 for i > j. A is called a lower-triangular matrix if ai j = 0 for i < j. A is calleda diagonal matrix if ai j = 0 for i = j.Theorem 56 (Fact 26.11, p.731). Th
University of Regina - STAT - 351
Stat 351 Fall 2007Assignment #9This assignment is due at the beginning of class on Friday, November 30, 2007. You must submitsolutions to all problems. As indicated on the course outline, solutions will be graded for bothcontent and clarity of exposit
University of Regina - STAT - 351
Statistics 351 (Fall 2007)Covariance Zero Does Not Imply IndependenceThe following exercise illustrates that two random variables can have covariance zero yet need notbe independent.Exercise. Consider the random variable X dened by P (X = 1) = 1/4, P
University of Regina - STAT - 351
Statistics 351 (Fall 2007)Fishers F -distribution and Statistical Hypothesis TestingFor Problem #4 on page 27 you are asked to manipulate Fishers F -distribution. The F -distributionarises in the following context. (See Section 10.9 in the Stat 251 tex
University of Regina - STAT - 351
Statistics 351.001 Fall 2008Final Exam InformationThe date and location of the nal exam are Friday, December 12, 2008, 9:00 a.m. 12:00 p.m. Education Building, room 230 (ED 230)Please ensure that you know where the location of the test room is and th
University of Regina - STAT - 351
Statistics 351 (Fall 2007)The Gamma FunctionSuppose that p > 0, and deneup1 eu du.(p) :=0We call (p) the Gamma function and it appears in many of the formul of density functionsfor continuous random variables such as the Gamma distribution, Beta di
University of Regina - STAT - 351
Statistics 351 Fall 2007Independence of X and S 2Theorem. Suppose that X1 , . . . , Xn are independent N (0, 1) random variables. If1X=nnXii=11and S =n1n2(Xi X )2i=1denote the sample mean and sample variance, respectively, then X and S 2 a
University of Regina - STAT - 351
Statistics 351 (Fall 2007)The Jacobian for Polar CoordinatesExample. Determine the Jacobian for the change-of-variables from cartesian coordinatesto polar coordinates.Solution. The traditional letters to use arex = r cos and y = r sin .However, to a
University of Regina - STAT - 351
Statistics 351 (Fall 2007)Review of Linear AlgebraSuppose that A is the symmetric matrix1 1 0A = 1 2 1 .013Determine the eigenvalues and eigenvectors of A.Recall that a real number is an eigenvalue of A if Av = v for some vector v = 0. We callv a
University of Regina - STAT - 351
Statistics 351 Midterm #1 October 10, 2007This exam has 4 problems and 6 numbered pages.You have 50 minutes to complete this exam. Please read all instructions carefully, and checkyour answers. Show all work neatly and in order, and clearly indicate yo
University of Regina - STAT - 351
Statistics 351 Midterm #1 October 6, 2008This exam has 4 problems and 6 numbered pages.You have 50 minutes to complete this exam. Please read all instructions carefully, and checkyour answers. Show all work neatly and in order, and clearly indicate you