financing

Name: Use the attached partial budget sheets to complete the three partial budget examples. Please show all your work, particularly payroll calculations Complete a partial budget for the following three exams: Partial Budget 1 The date is January 1st2023. - Your proposed change is to board 25 head of elite livestock (goats, horses, cows). You must build a barn that will cost $20,000 yearly, including depreciation, taxes, taxes, and Insurance. - The market rate for board is $300.00 per livestock per month. - You will no longer be able to rent your 50 acres of land for 70 dollars per acre per year. - You will need to hire one full-time person at 40 hours per week, and you must pay that person NYS minimum wage. The person will get two weeks of paid vacation. You must pay social security, Medicare, and workers' compensation. The rate for workers comp is 5 percent. - You will no longer need to fertilize your 50 acres of land. Your historical fertilizer bill was $200.00 per acre. - The opportunity cost for your $20,000 investment is earning 10% in the stock market. 1. How much will you make in year one 2. If you are only able to board 15 head of elite livestock, how much money will you make Your proposed change is for owning a tractor and manure spreader vs. hiring someone to spread the manure generated by your livertock. You can spread your own manure and your neighbor's manure tool It will cost you $10,000 yearly for depreciation, interest, and insurance for your tractor and manure spreader. If you spread your manure, you will need to give up your moming postal route, paying $100.00 per day. You are a substitute route driver and only work 150 days each year. Your neighbors will pay you $6,000 per year to spread the manure generated by their animals. You estimate the annual truck repair at $8,000, per year. You will not need to hire someone at $12,000 per year to spread the manure generated by your animals. You estimate that the cost purchase gas for your tractor will be 4.00 a gallon, and you will need to purchase 1,000 gallons each year. 1. What will be your profits in the scenario above? 2. What will be your profits if gas prices go to $6.00 per gallon? In analyzing your expenses, you noticed your bagged feed (could be seed) costs are incredibly high. Last year alone, you purchased 500 bags of product (feed/seed), and each bag costs $20.00, and each bag is 100 pounds! You phoned the local equipment dealer and leamed that the annual depreciation, insurance, and interest on a large bulk bin is $5,000. The opportunity cost of the $5,000 is 10 percent. If you purchase the bulk bin, you will no longer need to pay your employee the 2 hours each week at $18.00 per hour (taxes included) for 50 weeks out of the year to pick up the bagged feed. The bulk feed will cost you .10 per pound. You will purchase 50,0001bs in one year. How much savings will the bulk bin be? PARTIAL BUDGET ADDIT'ONAI EnCTE