Hi, was just wondering if anyone could double check my work? I have a feeling it is wrong, but if you could explain to me the correct way, that would be appreciated. ****data in red****

Home Insert Page Layout Formulas view Help Comments Calibri 12 - A A a Wrap Text General Bad Good Neutral AY X Cut Paste La Copy Format Painter Clipboard Normal Conditional Format as Calculation Formatting Table AutoSum Fill Clear B I U A C Merge & Center Insert Delete Format Check Cell $ % Explanatory... Input Sort & Find & Filter Select Analyze Data Font Alignment Number Styles Cells Editing Analysis K19 X fc A B C D E F G H 1 K L M N O P 0 R S T U v w X Y Z AA AB AC AD AE AF B c Total $200,000 (360,000) 200,000 $100,000 $100,000 Amount of profit Salary allocation Balance Interest allocation: $160,000 A Opening . $70,000 $60,000 $70,000 3,500 Rate 5% 5% 5% 3,000 3,500 (10,000) (190,000) ($38,000) Balance Fixed ratio allocation A B Balance Allocated to ($190,000) ($190,000) ($190,000) 20% 30% 50% ($57,000) ($95,000) 190,000 SO Wws needs to be $65,500 $46,000 $68,500 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 3 34 35 36 37 38 input values Hit F9 to update formulas (or set your formulas to automatically update) Re1 to Beau5 Reau 6 to 7 Gen In Allor Trial Bal Erl Strats Dart liau Conwright B $100,000 $100,000 Total $200,000 (360,000) (160,000) Amount of profit Salary allocation Balance Interest allocation: $160,000 Rate Opening cap $70,000 $60,000 $70,000 5% 3,500 5% 3,000 5% 3,500 (10,000) 170,000 A B Balance Fixed ratio allocation A B Balance Allocated to partners $34,000 $170,000 $170,000 $170,000 20% 30% 50% $51,000 $85,000 (170,000) $0 his needs to be so $137.500 $154,000 $248,500 input values Hit F9 to update formulas (or set your formulas to automatically update)