I need help with the formulas for all of the yellow squares, Excel Assignment Homework Help

Anonymous
timer Asked: May 17th, 2016
account_balance_wallet $25

Question Description

This is FIN/370  I am really confused about the formulas for the questions in the yellow. If someone can please help me to understand these formulas

This is what out instructor advised as well:

Please note the beginning cash balance for January is the ending cash balance of December.  Please note you are providing calculations from January to June. 


Unformatted Attachment Preview

Precision Machines Student Note: Fill in the light yellow cells Data: Annual Cost of borrowing Minimum Cash Balance Beginning Cash Balance Revenues (Sales) Cash Collections First Month (30%) Second Month (35%) Third Month (35%) Total Collections Cash Disbursements Material Purchases Salaries Wages Other Expenses Capital Expenditure Dividends Interest Total Disbursements Cash flows Net cash flows Cumulative cash flows Minimum Cash Balance Cash Surplus or (Deficit) Recommendations: November December January February $40,000.00 $50,000.00 $48,000.00 $55,000.00 November December January February 6,000.00 3,000.00 6,000.00 3,500.00 10.00% $5,000.00 $7,500.00 March April May June $35,000.00 $50,000.00 $65,000.00 $40,000.00 March April May June 6,000.00 3,000.00 6,000.00 3,200.00 6,000.00 3,500.00 6,000.00 3,000.00 45,000.00 1,000.00 1,000.00 ...
Purchase answer to see full attachment

Tutor Answer

geniusy_2006
School: UCLA

Hi,How are you!Please find the excel file attached.I am also attaching the word document, which u can use for recommendation. (pls change some wordings if possible).When you need the finals for the course.Thanks for accepting the bid.  Bye

Precision Machines
Student Note: Fill in the light yellow cells
Data:
Annual Cost of borrowing
Minimum Cash Balance
Beginning Cash Balance
Revenues (Sales)

Cash Collections
First Month (30%)
Second Month (35%)
Third Month (35%)
Total Collections
Cash Disbursements
Material Purchases
Salaries
Wages
Other Expenses
Capital Expenditure
Dividends
Interest
Total Disbursements
Cash flows
Net cash flows
Cumulative cash flows
Minimum Cash Balance
Cash Surplus or (Deficit)

Recommendations:

November

December

January

February

$40,000.00

$50,000.00

$48,000.00

$55,000.00

November
$12,000.00

December
$15,000.00
14,000.00

January
$14,400.00
17,500.00
14,000.00
$45,900.00

February
$16,500.00
16,800.00
17,500.00
$50,800.00

$20,000.00

$25,000.00
6,000.00
3,000.00

$24,000.00
6,000.00
3,500.00

$34,000.00

$33,500.00

10.00%
$5,000.00
$7,500.00

$11,900.00
$19,400.00
$5,000.00
$14,400.00

$17,300.00
$31,700.00
$5,000.00
$26,700.00

March

April

May

June

$35,000.00

$50,000.00

$65,000.00

$40,000.00

March
$10,500.00
19,250.00
16,800.00
$46,550.00

April
$15,000.00
12,250.00
19,250.00
$46,500.00

May
$19,500.00
17,500.00
12,250.00
$49,250.00

June
$12,000.00
22,750.00
17,500.00
$52,250.00

$27,500.00
6,000.00
3,000.00

$17,500.00
6,000.00
3,200.00

$25,000.00
6,000.00
3,500.00

$32,500.00
6,000.00
3,000.00

45,000.00
1,000.00
$82,500.00

($35,950.00)
$5,000.00
$5,000.00
$0.00

1,000.00
1,425.00
$28,125.00

$18,375.00
$18,375.00
$5,000.00
$13,375.00

$34,500.00

$14,750.00
$28,125.00
$5,000.00
$23,125.00

$42,500.00

$9,750.00
$32,875.00
$5,000.00
$27,875.00


1

Precision Machines Part 2
FIN/370

Precision Machines
2
Introduction
To make any strong company understanding and using financial tools is essential to the
success. A cash budget helps a company to deter...

flag Report DMCA
Review

Anonymous
Thank you! Reasonably priced given the quality not just of the tutors but the moderators too. They were helpful and accommodating given my needs.

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors