finance assignment

profilespark123
answer_from_joymercy.xlsx

Sheet1

year201x Jan Feb dollars Apr May Jun Jul Aug Sep Oct Nov Dec total averages
Total Assets $500,000 $475,000 $460,000 $470,000 $475,000 $485,000 $495,000 $555,000 $600,000 $650,000 $700,000 $750,000 $6,615,000
Current Assets $250,000 $220,000 $199,900 $204,698 $204,392 $208,980 $213,459 $262,829 $307,085 $351,227 $395,251 $439,156 $3,256,977 271,414.75
fixed assets $250,000 $255,000 $260,100 $265,302 $270,608 $276,020 $281,541 $292,171 $292,915 $298,773 $304,749 $310,844 $3,358,023 279,835.25
Year 201X + 1
Jan jan feb mar apr may jun jul aug sep oct nov dec
Total Assets $600,000 $570,000 $552,000 $564,000 $570,000 $582,000 $594,000 $660,000 $720,000 $780,000 $840,000 $900,000 $7,932,000
Current Assets $350,000 $350,000 $352,100 $359,302 $365,608 $373,020 $380,541 $397,171 $412,915 $428,773 $444,749 $460,844 $4,675,023 389,585.25
fixed assets $250,000 $220,000 $199,900 $204,698 $204,392 $208,980 $213,459 $262,829 $307,085 $351,227 $395,251 $439,156 $3,256,977 271,414.75
Estimate the levels of permanent and temporary current assets for Comfin over these months. Find the average amount for fixed assets, permanent current assets, and temporary current assets in the year 201X and year 201X + 1.
i)permanent current asset for year 201x
total for 201x is equal to=fixed assets-current assets= $101,046
ii)temporaryt current asset for year 201x+1
total for 201x is equal to=fixed assets-current assets= $1,418,046
ii)Find the average amount for fixed assets,
201x=279,835.75 dollars
201x1=271,414.75 dollars
permanent current assets, and temporary current assets in the year 201X and year 201X + 1.
201x= $3,256,977
201x+1=389,585.25 $4,675,023
b)average amounts of short-term and long-term financing should Comfin have during each year if it wants to follow a maturity-matching financing strategy over
short term financing averages=201x+201x+1 divided by 2.
i) $5,594,489
ii)long term averages $6,615,000
c)

Sheet2

Sheet3