THIS IS FOR FINANCIAL MANAGEMENT. Use the writeup to fill out the 2 data charts please using excel.

I added a clearer version of the write up if any issues occur.

THIS IS FOR FINANCIAL MANAGEMENT. Please answer all parts of the question.

QwikShare is a new not-for-profit organization that will rent low-emissions automobiles at QwikStops in suburban areas in order to provide an environmentally friendly transportation option to its customers. The organization plans to rent automobiles by the day only, and it will operate 7 days a week, 365 days per year.

On the first day of FY 2019, QwikShare will take out a pre-approved loan of $240,000. The loan will have an annual interest rate of 4%, with annual principal repayments of $30,000 per year to begin in FY 2020. Principal repayments and interest payments will be due the last day of each fiscal year. The organization will immediately use the loan to purchase its first fleet of 15 automobiles. Each automobile will be purchased for $15,000, will have a useful life of 7 years, and can be sold for $2,000 at the end of its useful life.

QwikShare will have a full-time staff that includes a Chief Executive Office, a Chief Financial Officer, an Operations Manager, two customer service agents, and two automotive technicians. Full-time staff salaries will total $560,000 in FY 2019, and health benefits will equate to 30% of full-time staff salaries. The organization will also employ 10 part-time staff members who will earn an average of $12.50 per hour in wages and will work an average of 20 hours per week. QwikShare will lease its office and QwikStop spaces for $11,000 per month, it will use $1,000 per month in water and electrical utilities, and it will use $2,000 in supplies per month. In addition, the organization will incur $800 per month per automobile in maintenance and insurance expenses. QwikShare will also cover the cost of fuel at a discounted rate; the organization anticipates that it will cost $25 per car per day that a car is rented. All expenses will be paid as resources are consumed, except supplies, for which the organization will pay with a two-month lag.

In the first month of FY 2019, QwikShare expects supporters will pledge a total of $950,000 in donations to help support its first year of operations. The donations will be received in the month in which they are pledged. QuikShare will charge $65 per day for an automobile rental, and rental fees are collected via pre-stored credit cards the moment customers enter the vehicles they have reserved. In addition, the organization will be supported by a new federal grant that will pay QwikShare $0.75 for every pound of carbon dioxide (CO2) emissions its rentals prevent during FY 2019. QwikShare estimates that each of its low-emissions automobiles will prevent 50 pounds of CO2 emissions per day they are in use during FY 2019. Revenues from the federal grant will be received with a one-month lag.

QUESTIONS:

A. Using break-even analysis, calculate the minimum number of automobiles QwikShare must rent per day in FY 2019 in order to break even. (Hint: Since the problem is asking for the break-even volume of rentals per day, you should make certain all of your values for each variable are expressed accordingly.)

Note: Use the template provided for this assignment. To receive full credit for this problem, you must use Excel and the Goal Seek function.

B. Using target profit analysis, calculate the minimum number of automobiles QwikShare must rent per day in FY 2019 in order to earn an annual profit of $135,000.

C. Prepare an annual operating budget for FY 2019, assuming the organization will rent 12 cars per day, on average, in FY 2019.

D. Prepare a quarterly cash budget for FY 2019 (showing each of the four quarters and the annual total), assuming the organization will rent 12 cars per day, on average, in FY 2019. Since this is a new organization, the beginning cash balance should be $0.

8:38 + 1 Owak bars is a new bus-for-profit organization that will consis Owik Supa in suburban was in order to provide an environmentally friendly transportation is to its comers. The organization plans to some by the dry only, and it will open 7 days a week, 365 days per year On the first day of FY 2010. aastate will take out a pre-approved loon of 5340,000 The loan will have an annual interest rate of 4% with a principal ayns of $30,000 per year to begin in FY 2020. Principal repayment and interest payment will be due the last day of each fiscal you. The organization will immediately the loan to purchase its first fleet of 15 automobiles Fachbile will be purchased for $15.000, will have a useful life of 7 years and can be sold for $2.000 at the end of its wide Shure will have a full-time staff that includes a Chief Executive Office, a Chief Financial Officer, an Operation Manager, two customer service aperte te automotive techniciant. Full-time staff alanes will total $560,000 in FY 2019. dhe benefits will equate to 30% of time afflariesThe animation will complex 10 parti staff members who will cam an average of $12.50 per borin and work an average of 20 hours per week. Ook Share will lease office and perces for $11.000 per month, it will use $1,000 per month in water and doctrical and it will use $2.000 in supplies per month In addition, the will per month por automobile in maintenance and insurance expenses. She will be cover the cost of feel at a discounted at the organization anticipates that it will cost $35 per car per day that a car is sented. All expenses will be paid assessmed. except supplies, for which the organization will pay with a two month ag In the first month of FY 2019. QwikShare expects apporters will pledge af $950,000 in donations to help support its first year of operation. The donations will be received in the month in which they are pledged that will charge 565 per day for automobile rental, and rental fees are collected via pre-scored credit cards the customers cater the vehicles they have reserved. In addition, the organization will be supported by a new federal grant that will pay Shane 50 for every part of dioxide (CO) missions ils rentals prevent during FY 2019. Qui est to the cach of its low-cms automobiles will prevent 50 pounds of CD, cm per a they are in use during FY 2019. Revenges from the federal grant will be received with one-month lag a Using broak-even atalysts, calculate the minimum number of tumbles Qwik Share mest rent per day in FY 2019 in ander bakeren (Het Sice the problem is asking for the beak-even volume of rentals per day you should make certain all of your values for each variable are expressed accordingly Note: Use the template provided for this assignment. To receive full credit for problem, you must use Excel and the Goal Seck function. b. Uning taryet profit malyse, calculate the minimum number of tomobiles Oik She mud rent per day in FY 2019 in order to com a anului $135.000 c. Prepare an annual operating budget for FY 2018, sauming the entie rent 2 cas per day, on average, in FY 2019. d Prepare a quanerly cash budget for FY 2019 showing each of the for and the mall) aming the anization will re 12 cas per day average, in FY 2019. See this is a new organization the beginning and balance should be so Qwik Share Annual Operating Budget FY 2019 Car rentals per day Revenues and Support Donations Rental fees Federal grant Total revenues Expenses Full-time salaries and benefits Insurance Part-time wages Fuel Rent Supplies Depreciation Utilities Interest Total expenses Profit/(Loss) 1A 1B 1C 1D Qwik Share Quarterly Cash Budget FY 2019 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Annual Beginning Balance Cash Receipts Donations Rental fees Federal grant Total cash receipts Available Cash Cash Payments Full-time salaries and benefits Insurance Part-time wages Fuel Rent Supplies Utilities Interest Total cash payments Subtotal Borrowing Repayments Investments Ending Cash Balance QwikShare is a new not-for-profit organization that will rent low-emissions automobiles at QwikStops in suburban areas in order to provide an environmentally friendly transportation option to its customers. The organization plans to rent automobiles by the day only, and it will operate 7 days a week, 365 days per year. On the first day of FY 2019. QwikShare will take out a pre- approved loan of S240,000. The loan will have an annual interest rate of 4%, with annual principal repayments of $30,000 per year to begin in FY 2020. Principal repayments and interest payments will be due the last day of each fiscal year. The organization will immediately use the loan to purchase its first fleet of 15 automobiles. Each automobile will be purchased for $15,000, will have a useful life of 7 years, and can be sold for $2.000 at the end of its useful life. QwikShare will have a full-time staff that includes a Chief Executive Office, a Chief Financial Officer, an Operations Manager, two customer service agents, and two automotive technicians. Full-time staff salaries will total $560,000 in FY 2019, and health benefits will equate to 30% of full-time staff salaries. The organization will also employ 10 part- time staff members who will earn an average of $12.50 per hour in wages and will work an average of 20 hours per weck. QwikShare will lease its office and QwikStop spaces for $11,000 per month, it will use $1,000 per month in water and clectrical utilities, and it will use $2,000 in supplies per month. In addition, the organization will incur $800 per month per automobile in maintenance and insurance expenses. QwikShare will also cover the cost of fuel at a discounted rate: the organization anticipates that it will cost $25 per car per day that a car is rented. All expenses will be paid as resources are consumed, except supplies, for which the organization will pay with a two- month lag In the first month of FY 2019, QwikShare expects supporters will pledge a total of $950,000 in donations to help support its first year of operations. The donations will be received in the month in which they are pledged. QuikShare will charge S65 per day for an automobile rental, and rental fees are collected via pre-stored credit cards the moment customers enter the vehicles they have reserved. In addition, the organization will be supported by a new federal grant that will pay QwikShare S0.75 for every pound of carbon dioxide (CO) emissions its rentals prevent during FY 2019. QwikShare estimates that each of its low- emissions automobiles will prevent 50 pounds of co, emissions per day they are in use during FY 2019. Revenues from the federal grant will be received with a one-month lag. 8:38 + 1 Owak bars is a new bus-for-profit organization that will consis Owik Supa in suburban was in order to provide an environmentally friendly transportation is to its comers. The organization plans to some by the dry only, and it will open 7 days a week, 365 days per year On the first day of FY 2010. aastate will take out a pre-approved loon of 5340,000 The loan will have an annual interest rate of 4% with a principal ayns of $30,000 per year to begin in FY 2020. Principal repayment and interest payment will be due the last day of each fiscal you. The organization will immediately the loan to purchase its first fleet of 15 automobiles Fachbile will be purchased for $15.000, will have a useful life of 7 years and can be sold for $2.000 at the end of its wide Shure will have a full-time staff that includes a Chief Executive Office, a Chief Financial Officer, an Operation Manager, two customer service aperte te automotive techniciant. Full-time staff alanes will total $560,000 in FY 2019. dhe benefits will equate to 30% of time afflariesThe animation will complex 10 parti staff members who will cam an average of $12.50 per borin and work an average of 20 hours per week. Ook Share will lease office and perces for $11.000 per month, it will use $1,000 per month in water and doctrical and it will use $2.000 in supplies per month In addition, the will per month por automobile in maintenance and insurance expenses. She will be cover the cost of feel at a discounted at the organization anticipates that it will cost $35 per car per day that a car is sented. All expenses will be paid assessmed. except supplies, for which the organization will pay with a two month ag In the first month of FY 2019. QwikShare expects apporters will pledge af $950,000 in donations to help support its first year of operation. The donations will be received in the month in which they are pledged that will charge 565 per day for automobile rental, and rental fees are collected via pre-scored credit cards the customers cater the vehicles they have reserved. In addition, the organization will be supported by a new federal grant that will pay Shane 50 for every part of dioxide (CO) missions ils rentals prevent during FY 2019. Qui est to the cach of its low-cms automobiles will prevent 50 pounds of CD, cm per a they are in use during FY 2019. Revenges from the federal grant will be received with one-month lag a Using broak-even atalysts, calculate the minimum number of tumbles Qwik Share mest rent per day in FY 2019 in ander bakeren (Het Sice the problem is asking for the beak-even volume of rentals per day you should make certain all of your values for each variable are expressed accordingly Note: Use the template provided for this assignment. To receive full credit for problem, you must use Excel and the Goal Seck function. b. Uning taryet profit malyse, calculate the minimum number of tomobiles Oik She mud rent per day in FY 2019 in order to com a anului $135.000 c. Prepare an annual operating budget for FY 2018, sauming the entie rent 2 cas per day, on average, in FY 2019. d Prepare a quanerly cash budget for FY 2019 showing each of the for and the mall) aming the anization will re 12 cas per day average, in FY 2019. See this is a new organization the beginning and balance should be so Qwik Share Annual Operating Budget FY 2019 Car rentals per day Revenues and Support Donations Rental fees Federal grant Total revenues Expenses Full-time salaries and benefits Insurance Part-time wages Fuel Rent Supplies Depreciation Utilities Interest Total expenses Profit/(Loss) 1A 1B 1C 1D Qwik Share Quarterly Cash Budget FY 2019 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Annual Beginning Balance Cash Receipts Donations Rental fees Federal grant Total cash receipts Available Cash Cash Payments Full-time salaries and benefits Insurance Part-time wages Fuel Rent Supplies Utilities Interest Total cash payments Subtotal Borrowing Repayments Investments Ending Cash Balance QwikShare is a new not-for-profit organization that will rent low-emissions automobiles at QwikStops in suburban areas in order to provide an environmentally friendly transportation option to its customers. The organization plans to rent automobiles by the day only, and it will operate 7 days a week, 365 days per year. On the first day of FY 2019. QwikShare will take out a pre- approved loan of S240,000. The loan will have an annual interest rate of 4%, with annual principal repayments of $30,000 per year to begin in FY 2020. Principal repayments and interest payments will be due the last day of each fiscal year. The organization will immediately use the loan to purchase its first fleet of 15 automobiles. Each automobile will be purchased for $15,000, will have a useful life of 7 years, and can be sold for $2.000 at the end of its useful life. QwikShare will have a full-time staff that includes a Chief Executive Office, a Chief Financial Officer, an Operations Manager, two customer service agents, and two automotive technicians. Full-time staff salaries will total $560,000 in FY 2019, and health benefits will equate to 30% of full-time staff salaries. The organization will also employ 10 part- time staff members who will earn an average of $12.50 per hour in wages and will work an average of 20 hours per weck. QwikShare will lease its office and QwikStop spaces for $11,000 per month, it will use $1,000 per month in water and clectrical utilities, and it will use $2,000 in supplies per month. In addition, the organization will incur $800 per month per automobile in maintenance and insurance expenses. QwikShare will also cover the cost of fuel at a discounted rate: the organization anticipates that it will cost $25 per car per day that a car is rented. All expenses will be paid as resources are consumed, except supplies, for which the organization will pay with a two- month lag In the first month of FY 2019, QwikShare expects supporters will pledge a total of $950,000 in donations to help support its first year of operations. The donations will be received in the month in which they are pledged. QuikShare will charge S65 per day for an automobile rental, and rental fees are collected via pre-stored credit cards the moment customers enter the vehicles they have reserved. In addition, the organization will be supported by a new federal grant that will pay QwikShare S0.75 for every pound of carbon dioxide (CO) emissions its rentals prevent during FY 2019. QwikShare estimates that each of its low- emissions automobiles will prevent 50 pounds of co, emissions per day they are in use during FY 2019. Revenues from the federal grant will be received with a one-month lag