Hi please answer and show formula. Thank you, I'll leave you a like!

Mohair Corp. has requested a new line of credit to address the seasonality of revenues. The request is for an $9,500,000 demand loan and resulted in your lender requiring a working capital analysis. You have been assigned the task of calculating the expected line of credit requirement based on the information provided below. The lender has suggested a covenant which limits the current ratio including any demand bank loan to no worse than 1.75:1. Given this is a future oriented analysis - use 360 days as a year. Your task: a) Prepare a schedule of working capital that determines what the maximum loan amount is which meets the proposed Current Ratio of 1.75:1 and conclusion if the request be met? ( 15 marks)