Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(SHOW FULL WORK AND EQUATIONS OF HOW YOU GOT EACH ANWSER) (SHOW WORK IN EXCEL) Question: 1c) Using the results from #2 prepare a model

image text in transcribed

image text in transcribed

(SHOW FULL WORK AND EQUATIONS OF HOW YOU GOT EACH ANWSER) (SHOW WORK IN EXCEL)

Question:

1c) Using the results from #2 prepare a model of the initial investment and incremental cash flows for the next 5 years. Utilize NPV, IRR & the payback period.

Exhibit 1 ACTUAL REVENUES AND COSTS FOR THE RESORT LAND-CLEARING JOB (in U.S. dollars) Per day Project 7 $375.00 $2,625.00 Calendar days needed to complete the project! Revenues Revenue per calendar day Total revenues Variable costs Transportation costs Round trip distance (miles) Rate per mile Transportation costs per calendar day Total transportation costs 80 $0.63 $50.40 (352.80) Shepherd and dog Rate per calendar day Total shepherd and dog costs Total variable costs per calendar day Contribution margin $190.00 (1.330.00) $240.40 (1,682.80) $134.60 $942.20 (100.00) Fixed costs Setup Fencing Linear feet Rate per linear foot Total fencing costs Total fixed costs Profit 962 $0.75 (721.50) (821.50) $120.70 The area cleared was one acre, or 43,560 square feet. At a daily forage rate of 250 square feet per goat, the job required 174.24 goat days. The trailer has a capacity of 25 goats, so it would take 6.97 days for the goats to finish clearing the land. By agreement, McCoy billed for a full trailer (25 goats) for a full day each day the goats were on site. Therefore, McCoy billed the owner for seven calendar days (175 goat days). Exhibit 2 FIXED AND VARIABLE COSTS FOR RESORT JOB (in U.S. dollars) Description Truck and trailer operation and maintenance costs per mile (transportation costs) Round trip to resort job site (miles per day) Shepherd and dog costs per day Setup costs for resort job Fencing costs per linear foot Linear feet of fence needed for resort job $0.63 80 $190.00 $100.00 $0.75 962 Exhibit 3 COSTS FOR LARGER TRUCK AND TRAILER (in U.S. dollars) Description Heavy duty pickup truck 20' used livestock trailer Taxes, title, etc. Total investment Cost $15,000 7,250 2.225 $24,475 Exhibit 4 ESTIMATED FIXED AND VARIABLE COSTS FOR GOAT RENTAL OPERATION WITH A LARGER TRUCK AND TRAILER (in U.S. dollars) Description Estimated truck and trailer operation and maintenance costs per mile (transportation costs) Average round trip to job site (miles per day) Shepherd and dog costs per day Setup costs per job Fencing costs per linear foot Average linear feet of fence needed per job Larger truck and trailer $1.25 80 $190,00 $100.00 $0.75 962 Exhibit 1 ACTUAL REVENUES AND COSTS FOR THE RESORT LAND-CLEARING JOB (in U.S. dollars) Per day Project 7 $375.00 $2,625.00 Calendar days needed to complete the project! Revenues Revenue per calendar day Total revenues Variable costs Transportation costs Round trip distance (miles) Rate per mile Transportation costs per calendar day Total transportation costs 80 $0.63 $50.40 (352.80) Shepherd and dog Rate per calendar day Total shepherd and dog costs Total variable costs per calendar day Contribution margin $190.00 (1.330.00) $240.40 (1,682.80) $134.60 $942.20 (100.00) Fixed costs Setup Fencing Linear feet Rate per linear foot Total fencing costs Total fixed costs Profit 962 $0.75 (721.50) (821.50) $120.70 The area cleared was one acre, or 43,560 square feet. At a daily forage rate of 250 square feet per goat, the job required 174.24 goat days. The trailer has a capacity of 25 goats, so it would take 6.97 days for the goats to finish clearing the land. By agreement, McCoy billed for a full trailer (25 goats) for a full day each day the goats were on site. Therefore, McCoy billed the owner for seven calendar days (175 goat days). Exhibit 2 FIXED AND VARIABLE COSTS FOR RESORT JOB (in U.S. dollars) Description Truck and trailer operation and maintenance costs per mile (transportation costs) Round trip to resort job site (miles per day) Shepherd and dog costs per day Setup costs for resort job Fencing costs per linear foot Linear feet of fence needed for resort job $0.63 80 $190.00 $100.00 $0.75 962 Exhibit 3 COSTS FOR LARGER TRUCK AND TRAILER (in U.S. dollars) Description Heavy duty pickup truck 20' used livestock trailer Taxes, title, etc. Total investment Cost $15,000 7,250 2.225 $24,475 Exhibit 4 ESTIMATED FIXED AND VARIABLE COSTS FOR GOAT RENTAL OPERATION WITH A LARGER TRUCK AND TRAILER (in U.S. dollars) Description Estimated truck and trailer operation and maintenance costs per mile (transportation costs) Average round trip to job site (miles per day) Shepherd and dog costs per day Setup costs per job Fencing costs per linear foot Average linear feet of fence needed per job Larger truck and trailer $1.25 80 $190,00 $100.00 $0.75 962

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Federal Budget Politics Policy Process

Authors: Allen Schick

3rd Edition

0815777353, 9780815777359

More Books

Students also viewed these Accounting questions

Question

=+What needs to be said first?

Answered: 1 week ago

Question

=+You couldn't expect more from a cow, could you?

Answered: 1 week ago