Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The accounting software used by your company provides lists of transaction data. The PPE list contains all of the transactions that impacted net property, plant,

The accounting software used by your company provides lists of transaction data. The PPE list contains all of the transactions that impacted net property, plant, and equipment during the year. Positive numbers are increases to the PPE account (purchases) and negative numbers are decreases (sales/disposals and depreciation, credits). On January 1, 2021, your company's beginning net PPE balance was 153,259,800. The list PPE contains all of the transactions that impacted net property plant and equipment from January 1, 2021 - December 31, 2021. Create a variable called TotalPPE and set this variable equal to the January 1, 2021 PPE balance. Write a for loop to add together all of the items in the list PPE. The for loop should update the variable TotalPPE so that, when the for loop completes, TotalPPE contains the ending balance in the PPE account. Note: There is a built-in Python function sum that sums all the values in a list. Do not use the sum function. I want you to use a for loop.

PPE = [-22539, 58277, -37200, 175266, -21190, 196703, -18602, 28397, -3930, 72834, -21950, 59524, -81455, 159818, -15153, 184817, -11735, 125546, -48940, 61842, -4040, 189576, -52440, 202492, -72940, 38672, -46665, 211867, -52622, 91019, -7493, 189396, -17674, 12996, -90662, 34238, -1039, 50129, -85925, 151490, -45103, 195492, -64262, 131286, -71670, 69421, -79086, 14746, -68040, 1192, -1464, 65744, -20009, 108266, -2180, 36552, -32306, 200143, -93251, 135208, -47952, 45909, -36622, 11050, -76950, 194407, -25449, 114523, -1892, 181922, -68481, 65576, -40299, 90624, -29056, 187805, -66884, 216007, -70900, 158298, -28571, 202276, -25732, 29617, -45545, 32456, -54432, 207845, -26555, 6940, -23139, 148227, -89361, 58481, -852, 64905, -7211, 154956, -83158, 47218, -78610, 115800, -74330, 77952, -97365, 13067, -83960, 10876, -90081, 199701, -68470, 44969, -35111, 185183, -16652, 173690, -93365, 154564, -32999, 135402, -93423, 162019, -46151, 48584, -76686, 58141, -54318, 200313, -38216, 129800, -95512, 57951, -43739, 146439, -55927, 52886, -43033, 52193, -31570, 205183, -38023, 119703, -56562, 189751, -90053, 128482, -36424, 167294, -25526, 39814, -35817, 73829, -1815, 48237, -60875, 10648, -75051, 165610, -12698, 52446, -30248, 62237, -46072, 133884, -94009, 125122, -55787, 177200, -84981, 125989, -34969, 16154, -79102, 94949, -83409, 91310, -31397, 137941, -43424, 211633, -43968, 28226, -88355, 53794, -32917, 197129, -31868, 34573, -33590, 156866, -52204, 20947, -8935, 209248, -152, 212381, -56517, 181878, -67313, 57700, -44306, 201283, -53023, 19717, -87394, 168634, -34046, 191921, -98096, 1146, -99095, 40853, -97389, 56813, -81819, 51820, -94988, 186958, -98891, 78155, -42506, 173296, -96712, 56396, -8345, 164825, -1496, 177074, -18245, 96532, -71107, 162260, -87899, 66174, -54405, 20489, -99474, 138834, -45493, 179035, -37491, 70274, -12897, 31858, -89567, 22426, -73865, 53029, -75060, 133860, -61722, 94041, -15008, 87053, -18456, 116469, -1949, 164045, -52308, 99685, -9287, 172167, -69657, 187134, -33348, 125776, -205, 22323, -39282, 36152, -26873, 77939, -27537, 98751, -64218, 16237, -15409, 68246, -81272, 24894, -40621, 194666, -55764, 121241, -50623, 10998, -75941, 130110, -96753, 14193, -32542, 31745, -60284, 56195, -45898, 45460, -41886, 129493, -55926, 125524, -95222, 190852, -101257, 163932, -12391, 15180, -82841, 178115, -28532, 148755, -6405, 187728, -64142, 207030, -19614, 82287, -74544, 14245, -12318, 66396, -75052, 115794, -64076, 48879, -54962, 179646, -101104, 16994, 1001, 185545, -3187, 171134, -23074, 191375, -71597, 20816, -39849, 83390, -16754, 81620, -90839, 68791, -13831, 149583, -28015, 117131, -75746, 138740, -15043, 79956, -17761, 191878, -54947, 83025, -27730, 82219, -92496, 205132, -18524, 197165, -23968, 125904, -7346, 182278, -40486, 194771, -25584, 194584, -90759, 85593, -77022, 155618, -59144, 170886, -79684, 40539, -94108, 195137, -53776, 194033, -30182, 26718, -26202, 219311, -87418, 216919, -60335, 96389, -53397, 163020, -76604, 32151, -4111, 31031, -31311, 94935, -1155, 29956, -89950, 217196, -42927, 38705, -63183, 59292, -87623, 126191, -9940, 15680, -11527, 130501, -45067, 88279, -42897, 65624, -16716, 217531, -30742, 161373, -20507, 62046, -75490, 196641, -61924, 155539, -30917, 31568, -49553, 141744, -93759, 126344, -24898, 61678, -6283, 740, -92732, 139835, -12411, 97514, -33452, 47871, -1621, 151260, -38330, 132979, -23819, 88711, -95872, 107820, -57455, 56803, -49569, 46390, -13003, 207725, -35847, 131029, -27074, 104243, -38450, 102801, -4972, 79907, -66635, 845, -19224, 36368, -22575, 10038, -45555, 111781, -90100, 188538, -59635, 207589, -7423, 93927, -36960, 172902, -95844, 59711, -63162, 203426, -72370, 9998, -38485, 15487, -93410, 20858, -35869, 38652, -83962, 145898, -48632, 209863, -95480, 56492, -77630, 31383, -78281, 63659, -19043, 67594, -16716, 167551, -8423, 148273, -21924, 138260, -71590, 29244, -94465, 118668, -85585, 104588, -10920, 78313, -20161, 111274, -96246, 99521, -39722, 45339, -99084, 45807, -77654, 131053, -53029, 102856, -6356, 134989, -47484, 141981, -23306, 124593, -58243, 96724, -21726, 160348, -67882, 51659, -64347, 140343, -91111, 212797, -63234, 174227, -94124, 21226, -89996, 31426, -97328, 172178, -76196, 217910, -28788, 102880, -78973, 154967, -17649, 87644, -73727, 107348, -17454, 87275, -67258, 151064, -66834, 5266, -40618, 24407, -71819, 201743, -50798, 194228, -58627, 216514, -99887, 200810, -10223, 62320, -5447, 206534, -92986, 173835, -31905, 10660, -14758, 128940, -98359, 100709, -61579, 78930, -12558, 59646, -38550, 176836, -84805, 161807, -77940, 153901, -33483, 72970, -99418, 137144, -66321, 10197, -17246, 37379, -13959, 86343, -43858, 61347, -3852, 163521, -95922, 6098, -41454, 21906, -88214, 181836, -71040, 6871, -43781, 217153, -46183, 153145, -31320, 181589, -83801, 176337, -83057, 73919, -16260, 51927, -36253, 99556, -97724, 12778, -36243, 151545, -58614, 132676, -96179, 185840, -58826, 115592, -66085, 82515, -46475, 204353, -26204, 120962, -12380, 79008, -89718, 66281, -90870, 39962, -51375, 162702, -5943, 176687, -98773, 90523, -670, 117357, -46399, 91528, -51952, 64980, -34262, 211599, -72638, 56888, -87849, 179791, -3422, 75103, -12859, 9209, -72872, 99563, -57000, 162781, -42885, 149470, -46726, 181588, -34021, 41386, -44510, 67548, -101030, 215124, -3894, 44097, -27214, 157357, -8110, 123451, -80028, 87822, -74219, 25882, -15183, 177751, -61318, 216910, -22379, 128283, -40532, 217034, -45270, 101327, -21054, 202425, -89996, 138827, -111, 155572, -74331, 48261, -16276, 119403, -3968, 32069, -10662, 163147, -72876, 76277, -25219, 209525, -18144, 8004, -63908, 199355, -73960, 106878, -56544, 193121, -62506, 46965, -90852, 210027, -8259, 40486, -77131, 196424, -39886, 112642, -79162, 190836, -68259, 214503, -85075, 190978, -13747, 193088, -88153, 94044, -75041, 184030, -27259, 92150, -7253, 218634, -42544, 183174, -1863, 4806, -7931, 157080, -40969, 90400, -87178, 88319, -70960, 211463, -40909, 18161, -27819, 58911, -99420, 175859, -953, 128324, -650, 53355, -33968, 121856, -56509, 126087, -35596, 179118, -29880, 67102, -75645, 49872, -58373, 90097, -97616, 137509, -36784, 171258, -20153, 199504, -88100, 110462, -62387, 153988, -87356, 49170, -87239, 143074, -73586, 56146, -64396, 199539, -19624, 154451, -93422, 94238, -86731, 206810, -18593, 18061, -97758, 1793, -83180, 160886, -42412, 131561, -63506, 121013, -74590, 34458, -91093, 71759, -12122, 177060, -9033, 18825, -48775, 169913, -54959, 92533, -52852, 167616, -30539, 107259, -66493, 177311, -72108, 200326, -11585, 65016, -24888, 45521, -9304, 208183, -69795, 36094, -78486, 160314, -12887, 132996, -58172, 29043, -56091, 196510, -18698, 103204, -63945, 72403, -74616, 35050, -99642, 123462, -48561, 83501, -16038, 180942, -53200, 80912, -6702, 214618, -5778, 91661, -15190, 147990, -10744, 87542, -75724, 213310, -10501, 73498, -30816, 165073, -46738, 84600, -99729, 145890, -31030, 202079, -57822, 27931, -69053, 159317, -42912, 42424, -92911, 15866, -46919, 146374, -37644, 54602, -63822, 10834, -101337, 171704, -13893, 147870, -12674, 28864, -56429, 195273, -5828, 56711, -15765, 101643, -17160, 158687, -94330, 199870, -73451, 103488, -23018, 145618, -37893, 107312, -68020, 62044, -83506, 52854, -51080, 78505, -76398, 23518, -43579, 47435, -8700, 13716, -45094, 141275, -36046, 192291, -57803, 36352, -6768, 169856, -14988, 102549, -36817, 78728, -76821, 133222, -21294, 34096, -11087, 207855, -67098, 15718, -93781, 65590, -92570, 86810, -39494, 148710, -93125, 52492, -94770, 56684, -55592, 189693, -73117, 28041, -87638, 27254, -64753, 183182, -6283, 118499, -32605, 182059, -12180, 43951, -7891, 41579, 759, 107200, -13988, 174554, -39694, 190702, -19919, 219471, -10001, 22276, -41486, 79507, -50007, 103374, -50302, 151951, -65413, 170232, -80321, 135239, -63464, 130544, -82923, 101138, -63066, 124780, -80723, 177860, -24281, 210453, -74659, 126697, -46204, 56942, -39267, 113061, -36908, 125077, -81925, 47427, -21798, 103066, -17434, 56385, -35405, 17607, -66928, 1132, -60974, 45587, -13537, 102537, -72360, 82826, -84449, 48022, -68069, 82353, -28451, 152264, -98772, 175218, -84182, 102625, -10602, 208991, -1057, 12610, -72226, 22089, -84554, 120929, -5316, 81661, -97324, 155552, -99495, 80228, -53047, 25545, -80822, 173930, -36726, 107703, -87830, 88187, -7305, 96819, -15664, 62044, -90220, 5048, -51132, 81225, -28526, 168055, -50483, 110121, -44283, 119284, -24116, 61568, -50380, 18951, -71569, 67935, -16107, 41553, -33796, 123424, -13453, 110920, -59507, 9918, -42438, 207825, -18410, 153338, -53516, 159135, -18246, 1010, -96127, 163319, -37135, 59321, -73731, 26534, -54808, 63011, -94047, 115489, -61067, 11899, -1009, 25400, -74560, 138263, -70667, 183144, -25097, 75599, -23254, 122207, -79355, 172499, -81428, 66588, -63327, 140458, -93367, 119937, -4704, 160815, -90173, 14508, -7984, 143008, -39412, 120184, -92059, 105237, -38888, 96990, -82572, 159734, -93874, 113098, -77702, 210992, -4065, 216713, -26105, 54575, -10737, 101735, -82873, 64221, -34644, 206783, -21614, 67224, -75385, 75083, -76913, 53207, 294, 7527, -27955, 87072, -69015, 64191, -25415, 64306, -19375, 125154, -80691, 25678, -79526, 154705, -58545, 164986, -37883, 19556, -61448, 159325, -40127, 204751, -25805, 48692, -46511, 180455, -58445, 129163, -31951, 11150, -29507, 126857, -58416, 119545, -88205, 109185, -65262, 61317, -26360, 176092, -24327, 215552, -25418, 108496, -96863, 140581, -55818, 53810, -96178, 210916, -23681, 127299, -21639, 113868, -33250, 150132, -86323, 174634, -41227, 88542, -35836, 121009, -95627, 210955, -7747, 152240, -89899, 84788, -72437, 125587, -42168, 149879, -60003, 30340, -17255, 151820, -30860, 165057, -24545, 86875, -97442, 51212, -70310, 206257, -55413, 117181, -84140, 23012, -69252, 31835, -51049, 211577, -6228, 174279, -97336, 128683, -36821, 195836, -96070, 59326, -29602, 210410, -32975, 10838, -15243, 74473, -18716, 58420, -46136, 52448, -69227, 76811, -95621, 82897, -75570, 16915, -4425, 72831, -73854, 62665, -83858, 75742, -36038, 205001, -54656, 189232, -30700, 146309, -81062, 129645, -14618, 125246, -3330, 26779, -2227, 214974, -50224, 166578, -38213, 179867, -45539, 74504, -81228, 26961, -73763, 82098, -21286, 130631, -94766, 16772, -58585, 182061, -81590, 38317, -35545, 19280, -67888, 11037, -20178, 165259, -59581, 148133, -54458, 116588, -17008, 136393, -87961, 84796, -77495, 162845, -40976, 182450, -34396, 96438, -47745, 167267, -88368, 29043, -77406, 134319, -85116, 179504, -251, 28973, -81611, 90848, -24731, 29835, -98327, 26582, -71599, 123455, -87267, 107182, -77739, 123116, -94390, 86881, -93101, 15487, -53175, 193099, -76949, 90573, -77926, 82359, -68322, 53510, -93002, 77887, -8111, 199772, -80715, 211550, -922, 175907, -100641, 95463, -94982, 164868, -72633, 72878, -21618, 138400, -36671, 210042, -79685, 174463, -91692, 103313, -80780, 31207, -32799, 177945, -3795, 12903, -93762, 11246, -96532, 64028, -18570, 49338, -48457, 147893, -22210, 158476]

# Write your code here

Write a program that calculates how many assets were purchased in 2021. (Purchases are positive numbers in the list.)

# Write your code here

Your manager wants to know how much depreciation the newly purchased assets added to depreciation expense in 2021. Assume that all assets purcahsed in 2021 have a useful life of 20 years. Your company uses the "Half Year Convention", which means that the company assumes any purchases made during the year occurred on July 1, 2021 (at the halfway point for the year), and only half of one year's depreciation should be included for the newly purchased items.

Create a variable addlDepr. After your code runs, the value of addlDepr should be the depreciation expense from assets purchased in 2021.

addlDepr = 0 # write your code here

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Internal Auditing CIA Part 1 2021

Authors: Muhammad Zain

1st Edition

B09B36MRH2, 979-8542949130

More Books

Students also viewed these Accounting questions

Question

8 3 6 . .

Answered: 1 week ago