finance problem need be done excel
Nursingpapertutors.com stands out as a reputable writing company that delivers high-quality papers specifically designed for nursing students. With its specialization in the nursing field, commitment to quality, customization, and originality, timely delivery, dedicated customer support, and emphasis on confidentiality, Nursingpapertutors.com provides invaluable academic support to nursing students. As a reliable partner in their educational journey, Nursingpapertutors.com helps nursing students excel academically and prepares them to become competent and knowledgeable healthcare professionals.
Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have gathered the following information:
MONTH SALES OTHER PAYMENTS
June $172,000 $80,000
July 142,000 75,000
August 121,000 70,000
September 93,000 50,000
October 76,000 45,000
November 81,000
April Sales: $115,000
May Sales 135,000
Collections : Month of sales 35%
Following month 55%
Two months after sale 10%
Inventory Purchases : 60% of next month’s projected Sales
Payments: Month of purchase 40%
Following Month 60%
Discount if paid I month of purchase 2%
Minimum Cash Balance: $25,000
Rate on Short Term Borrowing 6%
Create a cash budget for June to October. Account for short-term borrowing and payback of outstanding loans and interest expense
Ending unadjusted Cash Balance end of May: $30,000
Nursingpapertutors.com places a premium on meeting deadlines. The company understands the significance of timely paper submissions for nursing students. To uphold their commitment to punctuality, Nursingpapertutors.com employs a well-organized workflow and efficient team coordination. This ensures that students receive their papers promptly, affording them ample time for review and making any necessary adjustments. Providing exceptional customer support is central to Nursingpapertutors.com’s mission. The company recognizes that nursing students may have queries or require assistance at any time of the day. As such, Nursingpapertutors.com offers 24/7 customer support to promptly address any concerns, clarify instructions, and offer updates on the paper’s progress. Their responsive support team ensures a seamless and positive experience for every student.